|
5.
Try it: Join Two Tables Go to
tblReceipt. Select a
Field: ReceiptID. Drag that
Field to tblMovieRented and place it on the one that matches:
ReceiptID. What Do
You See? The two Tables will be JOINED by
their common Key: ReceiptID. There is
more to this relationship. Try
This, Too: Edit the Relationship
Double-click the JOIN (the line) between tblReceipt and
tblMovieRented. What Do
You See? The Tables are JOINED by a matching Key: ReceiptID. This is a
One-to-Many Relationship. One:
tblReceipt Many:
tblMovieRented Keep
going...
Memo to Self: The Edit
Relationships window may pop up by default when you make a join.
Relationship Tools ->Design->Tools->Edit
Relationships
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4. Set relationships: Edit the
Relationships |
|
| |
