The form “frmTools_Dimensional” works perfect. The new form that is going to be similar is called “frmTools_Deflection”. It is close to what is needed.
However when you try to enter data into Date of Inspection Checks you get an error saying “You cannot add or change a record because a related record is required in table “tblDimensionVerification”
I have adjusted the table relationships several times with no improvements. Some how the sub form “subfrmInspectionChecks” is pointing to “tblDimensionVerification”
I am trying to create the same table relationships between for “frmTools_Deflection” as exists for ‘frmTools_Dimensional.
Take a look at the table relationships
Can someone take a look at this please.