How do you create a form with 4 tables and have the data transfer

M

MaryBethK

I want to use only one form format and have all the data I enter transfer to
the correct tables. Is there a way to have the same field on each table for
the transferance?
 
D

DL

If you mean you have the same field in each table, (identical data) , you
need to rethink your table design
 
M

Mike Revis

If you mean you have four tables. Each table with distinct related data. You
can have a primary key field in each table with a foreign key field having
the
same name in the related table.

Table 1 has primary key field named (insert your field name here)
Table 2 has foreign key field named the same as the primary key field in
table 1.
Table 2 has primary key field named (insert your field name here)
Table 3 has foreign key field named the same as the primary key field in
table 2.
And so on.
After setting your relationships between the tables you can then build a
query based on the 4 tables and construct your form
based on the query.

Mike
 
Top