"You cannot add or change a record . . . . "

[JimJones]

Hi,

I have the error message:

"You cannot add or change a record because a related record
is required in table "Service" "

(Service is a subform off my main form.
I have a tab control, with two tabs. The second tab is for the service details form. The first tab is the actual "Service" form.

I start a new service ticket in the "Service" form, and tab over to enter the details. It links to the service ticket# (Primary key) just fine, but when I enter any data, and hit enter, I get the error message.

Even the underlying Service table is properly updated with the PK.

Please help,

Jim

 

[scottfarcus]

The field in your main table that relates to the Service table is indexed.

 

[JimJones]

The field in your main table that relates to the Service table is indexed.

Thank you for your response. But even though I've since changed the data base to another state which still doesn't work properly, it was never the case for any field in my "main form" to be related to any field in the sub form, except for "CustomerNumber". Even then the subform was getting the CustomerNumber from another subform.

In its current state, the database accepts all data, but a pop-up form I just created is not displaying all the data, not is it accepting CustomerNumbre or Serviceticket number.

I am baffled. Please, if you would, see my more recent post(s).

Thanks,
Jim