|
We want to
link the Rental Price to the Movie Table.
So, we need to add a Field for the RentalPriceID to the Movie Table.
5. Try
This: Add a New Field Field
Name: RentalPriceID Data Type:
Number What Do
You See? Look at the Field Properties. Field
Size: Long Integer (Integers are Whole numbers, "Counting
Numbers." )
Indexed: Yes. Duplicates are OK. Many movies will have the same
Rental Price. Do This,
Please: Save the Table. Go to
File->Save. Close
tblMovies.
Memo to Self:
RentalPriceID is still
a Key, but it is not the Primary Key for tblMovies. So,
RentalPriceID is considered a Foreign Key, because it belongs to
another Table.
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4. Set relationships: Use Primary
Keys to create Relationships
Table Tools ->Design |
|
| |
