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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Update Two Tables Using One Form Contents 0
Autonumber is reusing previously assigned numbers-creating duplica 3
Combobox control source differs from view 2
Form Field Autofill from Table of Information 2
Linking Tabs 3
troubleshoot form 1
Duplicating records 3

Back
Top