cannot add or change a record because a related record is required

[colonial]

Hi, I really need help with a form and a subform.

The main form is the WorkOrder. I select the FleetID from the dropdown list and this creates a WorkOrderID number.
Then I enter the ServiceTypeID number which brings up a list in the subform of all the ServiceItems that belong to the ServiceTypeID.

My problem is when I select on the checkbox to mark a Service Item as Completed I get an error message saying “You cannot add or change a record because a related record is required in table “tblServiceItemsID””

I’ve tried various ways of changing my relationship structure, my queries and form and this is the closest I have ever got to getting the form to do what I want.

Can someone shed some light on what the problem is, and how may I resolve it please….

Attached are screenshots of the relationships, queries and form.

 

[mhartman]

Hello

The problem most likely is that your complete record as defined by your relationships in incomplete. You have a blank somewhere thats not getting filled in.

Regards
Mark

 

[mhartman]

Hello again.

A good way to trouble shoot the problem would be to start with just your primary table and ONE subordinate table in the relationship. Then run your form with just that to see if it completes the record and lets you advance. Then add the next table and do the same procedure.

Regards
Mark