When referential integrity is enforced on a one-to-many relationship in Access, you may not delete a record in the "one" table that has related records in the "many" table.

Question

Quizplus · Accepted Answer

Referential integrity ensures that relationships between tables remain consistent. When it is enforced, deleting a record in the "one" table that has related records in the "many" table is not allowed, as it would leave orphan records in the "many" table.

When Referential Integrity Is Enforced on a One-To-Many Relationship in Access