I have created a tabbed form, based on a multi-table query, with 4 subforms in it. Application is the main table in the db, with the primary key,id, being an autonumber and all other tables are related to this table via the id field, which is a number field.
For each new record i create, there is a corresponding id (coming from the application id autonumber) which is stored in each of the relating tables. As i fill out the fields in my form, there doesn't seem to be a problem, not until i move the cursor into the 2nd tab, and 2nd subform, when i get a message "You cannot add or change a record because a related record is required in the table 'Application'.
Would be grateful if anyone could help with this!!
For each new record i create, there is a corresponding id (coming from the application id autonumber) which is stored in each of the relating tables. As i fill out the fields in my form, there doesn't seem to be a problem, not until i move the cursor into the 2nd tab, and 2nd subform, when i get a message "You cannot add or change a record because a related record is required in the table 'Application'.
Would be grateful if anyone could help with this!!