TechTalk: Performance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Edit the Relationships 4. Join tblReceipt and tblMovieRented ReceiptID is the Primary Key in tblReceipt ReceiptID is the Foreign Key in tblMovieRented   Double-click the join from tblReceipt to tblMovieRented to edit the relationship.   A receipt has a One-To-Many design. One receipt can have many movies rented. When you delete a record in tblReceipt, the related records in tblMovieRented will be deleted.   Enforce Referential Integrity Referential integrity synchronizes the data in the tables. The options are: Update Related Fields Delete Related Records.   Memo to self: the Computer Mama is not comfortable deleting records. On the other hand, there are several benefits to archiving the data. Relationship Tools->Design-> Join Type