|
2.
What Do You See? The Relationships Window has opened. The
Relationship Tools are available. What
Else Do You See? Our database has a pair of Tables that are
joined by a common Key field: RentalPriceID. The
relationship, or join, is represented by the line from RentalPriceID
in the Movie Table to RentalPriceID in the Rental Prices Table. This
relationship was created when we added tblRentalPrices as a
Subdatasheet to tblMovies and linked the Parent and Child by
RentalPriceID. Microsoft Access noticed the matching Keys and
prompted us to create a relationship between the two Tables. Keep
going...
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4. Set relationships: Edit the
Relationships
Database Tools ->Relationships->Relationships |
|
| |
