Adding data through form

[wop0703]

I have a form, created from a query. The query contains and links about six tables using an AutoNumber ID. The query also has fields from each of these tables.

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. Therefore, not every table will contain information. But there will be times later on that some of that information will become available and will need to be placed on the appropriate spot (based on the ID number.)

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.

Thank you.

 

[wazz]

typically, when you enter data into a field, the field is part of a single table, so, only that one table is updated. the order of data entry must be organized to avoid data entry anomalies/errors.

"How should I go about resolving this when someone enters new data, each table's ID is autoincremented no matter if that table contains information immediately or not?"

this does not really make sense. there must be data (entry) for the ID to increment. a foreign key field does not automatically update itself with data when the primary key field is updated with data.

 

[neileg]

Please don't double post.