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
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