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