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 2010: Example of the
Completed Receipt Form