Addidng data to multiple Tables

[wop0703]

I have a form, created from a query. THe query contains an links about six tables using an AutoNumber ID.

OK, so when users enter their data into this form, I would like the autoincremented number to increase in each of these tables. The catch is that when the user enters data he/she does not have to enter data into every field.

So, some of my tables do not auto-increment and some do. How should I go about resolving this so that when someone enters new data, each table's ID is autoincremented no matter if that table contains information immediately or not? Please Help.

 

[neileg]

So you want to create a record in your tables even if it is blank?

Surely, what you should be doing is using an autonumber in your main table as the primary and populating your subsidiary table records with this value if there is a need for a record. Holding the value of another table's primary key like this is known as a foreign key.