Two tables one form

[REDaughdril]

I have two tables with the same information (Name, address, phone)as well as other information. In most cases it has alot of the same information, but can be different hence two tables two primary keys. We presently key information in one table (subform) and the other information(separate subform). I would like an easy way to, when the information is the same, key the information only once and it be entered in both tables.

Again as always thanks for all of the great help and support.

 

[Travis]

This is a good case to use an append query. Using the ID of the table you did enter the data into append all the info into the second table (minus the ID field of course) Use a button on the data entry form to launch the append query.