Good afternoon all
This one may be for the forms section so please feel free to move to teh correct forum.
I developed an access db application for an end user in work, which consists of 6 tables and two forms.
The form I have a problem with consists of 3 of the tables, in a one-to-one relationship, and are linked with a common primary key field MMDBID
A recent request has come in and I requrie an additional table in a one to many relationship. The additional table is on the many side linked with field MMDBID.
The forms record source is based on a query which includes all fields of the 3 existing tabled and now the 4th table. The form itself now contains the additional fields of the 4th table, and I have added additional code so that the primary key fields on the form are updated
However, once all fields are filled, on submitting the form to the next process of the app I get an error You cannot add or change a record because a related record is required in table "tblfundedit"
Is there any way I can update the primary tables first, before updating the new child table?
Many thanks
Larry
This one may be for the forms section so please feel free to move to teh correct forum.
I developed an access db application for an end user in work, which consists of 6 tables and two forms.
The form I have a problem with consists of 3 of the tables, in a one-to-one relationship, and are linked with a common primary key field MMDBID
A recent request has come in and I requrie an additional table in a one to many relationship. The additional table is on the many side linked with field MMDBID.
The forms record source is based on a query which includes all fields of the 3 existing tabled and now the 4th table. The form itself now contains the additional fields of the 4th table, and I have added additional code so that the primary key fields on the form are updated
However, once all fields are filled, on submitting the form to the next process of the app I get an error You cannot add or change a record because a related record is required in table "tblfundedit"
Is there any way I can update the primary tables first, before updating the new child table?
Many thanks
Larry
