If you select Cascade Update Related Fields when you define a relationship,then when the primary key of a record in the one side table changes,Access automatically changes the foreign keys in all related records.

Question

Quizplus · Accepted Answer

When you select Cascade Update Related Fields, Access automatically updates the foreign keys in all related records if the primary key of a record in the one side table changes.

If You Select Cascade Update Related Fields When You Define