populating 2 tables with data

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

Guest

Is it possible to enter data into a form created for one table and have that
data autopopulate another table not directly linked to it (although liked
through other tables)? If so what do I do?? If not how do I enter data into
one table and have that data populate another table at the same time? (Second
table has data that cannot be included on the first table)
 
Give us an example.

Your description sounds as though you are duplicating information which
would not be correct database design.

Rick B
 
Is it possible to enter data into a form created for one table and have that
data autopopulate another table not directly linked to it (although liked
through other tables)? If so what do I do?? If not how do I enter data into
one table and have that data populate another table at the same time? (Second
table has data that cannot be included on the first table)
Click to expand...

Why would you WANT to store the same data redundantly in two tables?

The second table should contain only a link to the first table, *not*
all of the data in the first table. The link can be maintained by
using a Form for the first table, with a Subform for the second table;
set the Master/Child Link Field properties of the subform to the
linking field.

John W. Vinson[MVP]
 
Back
Top