In MS Access, the 'Cascade Update Related Fields' option will:
A. Automatically update the foreign key in related records when the primary key is changed
B. Prevent deletion of records that have related records
C. Copy the primary key to child table
D. Delete related records when the primary record is deleted
Answer: Option A
Solution (By JKSSB Mock Tests)
Cascade Update updates foreign keys. Cascade Delete deletes related records.
No comments yet. Be the first to start the discussion!