Hello everyone,
I have table in the Access Database, which is updated almost everyday.
Lets name this table as Table I
The Table I contains the following columns
Project ID "##########" 12 Digit Number
Project Name
Project Date
Valuation
Project City
Owner
Owner City
Our District
Sub Branch
Sent To
Project Leader
Sent On Date
Proposed Product 1 Check box
Proposed Product 2 Check Box
..
..
Proposed Product 6 Check Box
The Proposed Products are listed as the check boxes in access, right
now the person first enter the data into an excell sheet, and then
these excell sheets from 4 people is hand overed to the guy who is
responsible for adding the information into the database, all by copy
pasting the fields, and checking up the check boxes for the associated
products listed with the Project ID.
What I want to do is to create a form, which will following fields
PART I
ID Number ########### ( 12 Digit Number ) ( Primary key )
Name Text
Date Date
Sent To Text
Leader / Manager Text
PART II
Date Called Date
Caller Text
Tries Number
Actual Product 1 Check Box
..
..
Actual Product 9 Check Box
NOTES Text
Part I, is the fields, where I want to fill in the Id Number, and want
the
other fields of PART I to be auto populate as per the record,
associated with
it in the Table I from the Database .
The table 2, is needed to get filled up using the form, which will
search
for the Project ID from table 1 and autopopulate the fields which are
associated with it, as described by the PART 1 of the Form, and then
show the
Actual products sold, as the check boxes, which are filled by the
operator while contacting the owner. Then the last step will be adding
all
the information filled up on the form to table 2, which is going to
have the following fields
---- Entries from Table 1 ------
ID Number ########### ( 12 Digit Number ) ( Primary key )
Name Text
Date Date
Sent To Text
Leader / Manager Text
--- NEW Entries-----
--------This is to track the process---------
Date Called Date
Called whom ? Text
number of Tries Number
--------Actual Products sold-----------
Project 1 Check Box
Project 2 Check Box
..
..
Project 6 Check Box
Part II fields are filled in after the data is searched from the Table
I
using this form. Once both Part I and Part II fields are filled, this
information should be saved into the Table II, which is the new table
and
going to be filled with the data of both Part I and Part II of the
form.
I do understand that there might be different way to design this. The
previous database was not designed by me. what are the possible ways
to
better construct the database and solve the problem I am facing.
Thanks again for your time.
noble