Normally,Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Question

Quizplus · Accepted Answer

This is known as referential integrity, and it is a feature of relational databases. It ensures that data remains consistent and prevents orphaned records in linked tables. If a record with a matching primary key in another table is deleted, it could result in a loss of data integrity, so Access enforces this restriction by default.

Normally,Access Prohibits the Deletion of a Record in Which the Primary