|
The
Receipt Subform will look up the data in a Table, tblMovieRented. Our
discussion always begins by reviewing the data.
1. Try This: Review the Record Source Go to
All Access Objects ->Tables. Open a
Table: tblMovieRented. Do This,
Too: Change the View Go to
Home->Views->View. Select a
View: Design View. What Do
You See? This Table, tblMovieRented, has
numbers only:
MovieRentedID (the Primary Key) ReceiptID
(a Foriegn Key) CustomerID
(a Foreign Key) MovieID (a
Foreign Key) DateRented
(Date/Time) This Table
is in Third Normal Form: the Key, the whole Key and nothing but the
Key. Please Close
tblMovieRented. Keep going. All Access Objects ->Tables
|
|
| |
