The following form “frmTools_Dimensional” seems to be properly set up but is giving the following error after I have entered data into the subfrmInspectionChecks and subfrmDimensional. At first the two subforms accept the data and give the correct tool ID (primary key of the table tools) but when I try to navigate to the next record I get the following error:
“You cannot add or change a record because a related record is required in the table ‘tblInspections’.
Look at the tablerelationships and you can see that they are correctly related. I don’t understand why I am getting this error.
This form also only see tools that are “Dimensional”
Ignore the other tables they will later be connected in the exact same manner but right now focus only on the three tables:
“tblTools”, “tblInspections” and “tblDimensionVerification”
Can someone take a look please.