In a table relationship, the ____ option requires Access to delete all records in the related table that have a foreign key value related to the primary table when a record is deleted in the primary table.
A) Edit Relationships
B) Enforce Referential Integrity
C) Cascade Delete Related Records
D) Cascade Update Related Fields

Question

Quizplus · Accepted Answer

The cascade delete related records option ensures that when a record in the primary table is deleted, all related records in the related table with foreign key values that correspond to the deleted record are also deleted. This maintains referential integrity between the tables.

In a Table Relationship, the ____ Option Requires Access to Delete