Update Seperate Tables

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

Guest

I have a form that inputs the correct information into a table. I have a
seperate table that more or less duplicates this same data fields. The first
form has a AutoNumber primary key. Is it possilble to duplicate this key and
copy it to the second table? Many thanks for taking the time to read this.
Any help appreciated.

Debbie D.
 
Create another field in the second table (double type, not counter, and not
key) and paste the counter from the first table into this field, that way you
can link records between the two tables.
 
Back
Top