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. Copy the primary key to child table
C. Prevent deletion of records that have related records
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!