Access: Screen Play Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Create -> Table Design New Subform Record Source The subform will be a list of all the videos your customers rented.  It will be similar to the receipt table.    Try it: Create a Table for Movies Rented Go to Create -> Table Design.   Add the following fields and data types:   MovieRentedID Autonumber ReceiptID Number CustomerID Number MovieID Number DateRented Date/Time   Make MovieRentedID the Primary Key.   Save the table and name it tblMovieRented.