|
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...
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4. Set relationships: Edit the
Relationships to Enforce Referential Integrity
Relationship Tools ->Design |
|
| |
