My table relationships are now correct. I saw the video on how to do this and I matched the connections to my tables.
However when I attempt to add a record via the form “frmInspectionsDimension” I get this error:
“You cannot add or change a record because a related record is required in table tblTools.”
In this form you are supposed to select the Tool ID which in this form only sees dimensional tools and then you enter in the Date Checked, Checked By, General Condition and Comments. You also enter any measurement checks that you might make.
If the table relationships are correct why doesn’t the form work??