Sync. Records Up

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

Guest

I have a main table, "MainData", that autonumbers a field called "AuditNumber".
4 other tables, "IVRData" "SpeechData" "CustomerData" "CallDetails", are
related by the "AuditNumber" field. In the 4 related tables the data type for
"AuditNumber" is just number, not auto number.
I have a query that pulls all the tables together for my data entry form.
How can I force access to put the autonumber that is assigned in "MainData"
when from the data entry form into the 4 related tables (field
"AuditNumber), so that the tables are all in sync?

I saw some questions like this in the forums, but they all had VB answers. I
don't understand exactly how to use the VB code that was suggested in these
similar problems.

Thanks
 
I believe that if you make the AuditNumber the primary key for each of the
table that when the data entry form is used the tables will populate with
whatever is selected.
 
Back
Top