Join the Other Tables
9.
Try it: Join the Other Tables
Drag the
Keys to create the following Joins. For each link that is created
the Edit Relationship window will prompt you to confirm that
the Keys match. Click Enforce Referential Integrity and click
Create.
From
tblMovieRented to tblCustomer:
Link the
CustomerID.
From
tblMovieRented to tblMovies:
Link the
MovieID.
Do This,
Too: Close the Relationships
Go to
Relationship Tools ->Design.
Go to
Relationships->Close.
When you
close the Relationships you will be asked to Save.
So....how
are these Tables related, now?