|
The
Beginning Guide to Microsoft Access 2010 introduced the database objects: Tables, Queries,
Forms and Reports. These lessons showed a one-to-one relationship.
The Movies Form has one Record Source: the Movie Table, tblMovies. The
Intermediate Guide to
Microsoft Access 2010 demonstrates several
methods of representing
one-to-many relationships. For example, there are many movies with
the same rating, say "PG," The
Advanced Guide to
Microsoft Access 2010 creates a link between the customers
and the movies: the receipt. The Receipt Form creates a many-to-many
relationship. Many customers return many times and rent many movies
each time. What Is
The Best Approach? These lessons will create the Receipt Form
and Receipt Report using Subforms/Subreports. The information will
be related by Key data. The Receipt Report will be formatted to fit
a small Point of Sale (POS) printer. Example of the
Completed Receipt Form
|
|
| |
