|
The Receipt
Form is an interesting challenge. The Receipt combines most of the
Tables in this database: Who (tblCustomer), Bought (tblMovieRented) What
(tblMovies). The Receipt Form represents a one-to-many relationship: one
customer gets many movies. So, there will be a Form and Subform.
In Receipt
Form, part 1, the focus will be on the ReceiptSubform. This Form
will list the movies rented. This is the "many" part of the one-to-many
relationship: many movies. This Subform
will be formatted as a Table, which is the way online forms and webpage
are designed. You may notice that the Arrange Tools in Microsoft Access are
very similar to the
Table Tools in Word or Excel. In Receipt
Form, part 2, we will design the Receipt Form so Users can find a
customer by a phone number. The Form and Subform will be linked by
common Keys and tested. |
|
| |
