graphic2
graphic1

The Receipt Form

The Receipt Form answers the question:

Who bought what?

 

This Form will combine data from three Tables.

Who: tblCustomers

Bought: tblMovieRented

What: tblMovies

 

In the following pages, we will create two new Tables that will be the Record Sources for the Receipt Form and ReceiptSubform.

 

The Receipt Subform will inherit three Key Fields from the Receipt Form. So the Table for the ReceiptSubform, tblMovieRented, has to be designed with that in mind.

Microsoft Office Access: Example of the Completed Receipt Form