ClientID is the primary key field in the Clients table, which is related to the Projects table through its ClientID foreign key field. In Access, what option should you select to update the ClientID field values in the Projects table if the ClientID field values change in the Clients table?
A)Entity Integrity
B)Cascade Update Related Fields
C)Cascade Delete Related Records
D)Validation Rule Property

Question

Quizplus · Accepted Answer

Cascade Update Related Fields option ensures that changes made to the value of a primary key in the parent table (Clients table, in this case) are automatically reflected in the corresponding foreign key in the related child table (Projects table). This maintains referential integrity by updating related foreign key values when the primary key value changes.

ClientID Is the Primary Key Field in the Clients Table