Required table reference not found

Topic

New Reply

Hi!

I’m beyond myself with frustration. I’ve spent hours looking for the source of the error that comes up “you cannont add or change a record because a related record is required in table contracts 1.” This is a database that I inherited and for the life of me I can’t find what is causing this. Table contracts 1 is a backup table that actually isn’t needed. I checked required fields, looked at code/events, checked the table relationships and can’t find it, so I’m uploading the database in the hopes that someone else can find what I’m missing.

When the DB opens, click the “receiving” button. In the “Jump to PO#” enter 15138. Click the “Ship this order” button. Place a check in the “Shipped complete” box, then close the form. This is where the error comes up. The [contracts] table is where the data is supposed to be stored.

Thanks,
Leesha

Reply | Quote

Replies

Forgot the DB file!!

Reply | Quote

You have posted the frontend database. Without the backend we can’t open anything.

Take care not to post sensitive information if you attach the backend!

Reply | Quote

Can you tell I’m sick of this one! I sent the wrong zip!

Leesha

Reply | Quote

I don’t get an error message. A new record appears in the Shipping/Invoice table (the record source of the form opened by the “Ship this order” button.

Reply | Quote

I don’t get an error message. A new record appears in the Shipping/Invoice table (the record source of the form opened by the “Ship this order” button.

Really? I just tried it again on my laptop and on the users workstation and we both get the error. If there is no number in the contract number text field it will close, but once there is a number (in the sample case I sent it should be 1234-abcd-5678-e) it gives the error re the contracts1 table.

Reply | Quote

I had some problems with the VBA code in the database. Once I solved those, the error message did appear.

I opened the Relationships window and clicked the Show all relationships button.

It turns out that there are more relationships than originally displayed. There is a relationshio between Shipping/Invoice and Contracts with enforced referential integrity, but also between Shpping/Invoice and Contracts1 with enforced referential integrity.
Since the Contracts1 table is empty, it is not possible to create new records in Shipping/Invoice.

You should delete the second relationship.
What is the purpose of the tables Contracts1, Purchase Details1 Purchase Details2, Purchases1?

Reply | Quote

According to the user, these tables were added during some testing on the database years ago when it crashed. He states they aren’t necessary. I didn’t do the “show all” (another new learning experience) and sure enough now I’m not getting the error.

Thanks!
Leesha

Reply | Quote