Review the Record Source
The
MovieRentedSubform will use a Table for the Record Source:
tblMovieRented. Please begin this lesson by reviewing the Table
Properties.
1.
Try it: Review the Record Souce
Go to All Access
Objects->Tables.
Open a Table:
tblMovieRented.
Go to
Home ->Views ->View-> Design View.
What Do
You See? This Table has Keys for:
Who (CustomerID)
Bought (ReceiptID)
What (MovieID)
The
DateRented is important. Our business model uses the DateRented
to calculate how many days since the movie was rented.
Close the Table.
Keep going..