over my head with programming

[tmcavilee]

new to ms access - i'm trying to get the autonumber in my main form to
copy to fields in my other tables - the customer Id is a constant
between my 4 forms - can anyone help????? starting to pull out my hair!

 

[Rick Brandt]

new to ms access - i'm trying to get the autonumber in my main form to
copy to fields in my other tables - the customer Id is a constant
between my 4 forms - can anyone help????? starting to pull out my
hair!

There is nothing about a database that automatically copies data like that.

If you use a form with subforms to enter records then the MasterLink and
ChildLink properties of the subform controls will cause the foreign key
fields to automatically be populated with the value from the parent record.
Is that what you are looking for?