In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected.

Question

In Microsoft Access 2016, a record in a primary table that has matching records in a related table can be deleted even if the option to cascade deletions to related records is not selected. ​

Quizplus · Accepted Answer

Without the option to cascade deletions selected, deleting a record in a primary table that has matching records in a related table is not allowed due to referential integrity rules, which prevent orphan records in the related table.

In Microsoft Access 2016, a Record in a Primary Table