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..

Home ->Views ->View->Design View