Form giving errors

[Justcam]

Hi
I keep getting this error when trying to work on some forms in my new database. I am new to Base…

I’m trying to create a recipe costing base …

And I’m linking Ingredients with suppliers.

When I enter new ingredient - I get this error … (I have a list box for supplier name - which is returning supplier_ID to the INgredient table.)

Integrity constraint violation - no parent SYS_FK_95 table: Ingredients in statement [UPDATE “Ingredients” SET “Name” = ?,“Supplier_ID” = ? WHERE “Ingredient_ID” = ?]

[Ratslinger]

Hello, Please post sample of Base file without personal/confidential information. It is also often necessary to know your specific LO version being used, your OS and which database is being used.

[Ratslinger]

Hello,

Did manage to realize what may be happening. This is an educated guess.

You have an ‘Ingredient’ table. This table has a field to link back to ‘Suppliers’ table. You have a form to enter data into ‘Ingredient’ table. The error would be created if the value placed into this linked field was not in the ‘Suppliers’ table. Did a test with basically same error:

The entered data is not correct. Can only assist further if a sample is provided.