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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If you mean you have the same field in each table, (identical data) , you
need to rethink your table design
 
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
 
Back
Top