New Data to Mulitple Tables

  • Thread starter Thread starter swlaw
  • Start date Start date
S

swlaw

I have a New Project Form where all new projects will be entered. The Project
Number is created by us in a numerical order (ie 09-1077 or 09-1078). The New
Project Data is stored in Project Data Table. The common item between all
tables will be the Project Number. Within the New Project Form there are
buttons to other forms (ie Shipping Status). When Shipping Status form pops
up I would like the Project Number to be displayed in the appropriate field.
Right now I cannot make this happen.. Can anyone help???
Thanks in advance for your help.
 
Create one-to-many relationship between your Project Data Table and the
others that feed the forms. Select Referential Integerity and Cascade Update
options for the relationships.
Use form/subform with Master/Child links set using the primary key field of
the Project Data Table and foreign key field of the other tables.
 
Thanks Karl. I am new to Access 2007 and may not understand all your comments.
Right now I have Project Data Table and Contractor Table in the Relationship
window. They are connected by ID to ID (1to1). How can I do one to many?
 
The field of the 'one' table must be designated as Primary Key field and
therefore the entries must be unique. Many people use an autonumber field
as it will always be unique but any type field will work. In table design
view click on the field to be primary and then click on the icon that is a
gold key. If the records are not unique then an error will occur that must
be corrected.
To find error create a totals query with the field twice, first as Group By
and secons as Count with criteria under the second as >1 to find duplicates.
The 'many' side field, known as 'foreign key', must match in DataType. If
the many side has records that are not in the primay you get an error. In
this case you must run an unmatch query to find the offending record.
 
Too bad I canb't send you the database. Maybe you could show me how..????
What ya think???
 
Back
Top