Review the Join

7. Try it: Review the Join

There should be a line between:

ReceiptID, the Primary Key in tblReceipt.

to ReceiptID, the Foreign Key in tblMovieRented.

 

Try This, Too: Edit the Join

The Join is more than just a line. It is a Relationship. Select the Join

Go to Relationship Tools ->Design->Tools.

Click on Edit Relationship.

 

The Edit Relationship Window will pop up.

Click on Join Type.

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