|
One
customer may get many movies. So, the
Receipt will have a Report and Subreport. The Subreport will list
the movies rented. The
rptMovieRented-POS Subreport will use a Query, rptMovieRentedSQ
with 3 Tables: tblMovieRented, tblMovies and tblRentalPrice.
Create the Query Source:
rptMovieRentedSQ
Open tblMovieRented in
Design View
Identify the Key Fields
Create a Select Query:
rptMovieRentedSQ.
Create the Subreport:
rptMovieRented-POS
The
rptMovieRented-POS Subreport will be a
Tabular Report formatted as a Table. The Controls and Headers have
to be edited before the Report can be resized for the narrow 2" POS
printer. That's the plan.
|
|
| |
