Create table that will automatically contain data from another tab

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

Guest

I want to be able to create a table that will contain data from another table
automatically when a linked data field is entered. I still need to be able
to change this data in the form if necessary. Is this possible?
 
buxton said:
I want to be able to create a table that will contain data from another table
automatically when a linked data field is entered. I still need to be able
to change this data in the form if necessary. Is this possible?
Click to expand...

No; but the good news is that it is neither necessary nor desirable either.
Storing the same data redundantly in two tables is NEVER a good idea.

Simply base your form on a Query linking the two tables, or use a Form based
on one table with a Subform based on the other, using the link field as the
master/child link field of the Subform control.

If I've misunderstood the situation, please accept my apologies and post a
further explanation.

John W. Vinson/MVP
 
Back
Top