If you type data in 1 table will it populate to another table?

J

Jwyffels

I have 2 tables linked in a relationship, is there any way if I type
information into a field in 1 table that it will auto populate to the same
field in the other table?
Thanks
 
R

Rick B

The same field in another table? That would not be wise. The whole point
of relational databases is to store data only once in one table, but create
links so you can pull related information from other tables.
 
J

John Vinson

I have 2 tables linked in a relationship, is there any way if I type
information into a field in 1 table that it will auto populate to the same
field in the other table?
Thanks
Click to expand...

No; but it is neither necessary nor desirable to do so. Creating an
empty "placeholder" record accomplishes nothing (other than to create
problems down the road when the record doesn't get filled in).

Instead, use a Form based on the "one" table, with a Subform based on
the "many" table for your data entry; use the linking field as the
master/child link fields on the subform control. When you start to
enter data in the Subform (but not before!), a new record will be
created with the linking field.

John W. Vinson[MVP]
 
Top