Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Enforce Referential integrity

Enforce Referential Integrity 6. Try it: Enforce Referential Integrity The goal of referential integrity is to prevent "widows and orphans." The Receipt is a Form with a Subform. The Tables for both the Form and Subform need to be updated.   Cascade Update Related Fields When you select Cascade Update Related Fields, you are editing the "one" side of this One-To-Many relationship. If a Record is edited in tblReceipt, than the matching Record in tblMovieRented will be updated as well.   Cascade Delete Related Fields When you select Cascade Delete Related Fields, you are editing the "many" side of this One-To-Many relationship. If a Record is deleted in tblReceipt, than the matching Record in tblMovieRented will be deleted as well: no widows and orphans.   Try This, Too: Create the Join Click on Create. Keep going... Relationship Tools ->Design