how to suppress this warning?

[gunitinug]

You cannot add or change a record because a related record is required in table 'table_name'

thx

[June7]

Don't set a relationship between tables that enforces referential integrity. But if you do that then you will probably end up with bad data that will give you headaches later.

You have a table named 'table name'?

[orange]

You have a dependency between tables and you are trying to add a record to the dependent table and there is no "related" record in the parent table.

For example: Consider
You have 2 tables Parents and children

You are trying to add a record in the children table and there is no record for this child's parent in the Parents table.

Unlike June7, I often set up tables and relationships to enforce referential integrity ( a feature of relational databases) to prevent situations that you are having.

Bottom line here with your set up, you must have a parent before you can have a child record for this parent.