In a table relationship, the ____ option requires Access to change the appropriate foreign key values in the related table when the primary key value is changed in the primary table.
A) Edit Relationships
B) Enforce Referential Integrity
C) Cascade Delete Related Records
D) Cascade Update Related Records

Question

Quizplus · Accepted Answer

The Cascade Update Related Records option ensures that when a primary key value is updated in the primary table, the appropriate foreign key values in the related table are automatically updated as well. This helps to maintain the integrity of the relationship between the two tables.

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