Advanced Report Design: The Report Diagram The Receipt Report has a Report and a Subreport. Again, this is a good place to draw out the designs.   Both Reports are based on a Query:   The Report uses rptReceiptSQ. This Query includes: tblMovieRented tblMovies tblRentalPrices CustomerNameSQ   The Subreport uses rptMovieRentedSQ. This Query has three Tables: tblMovieRented tblMovies tblRentalPrices   The Receipt Report and Subreport are linked by one Key: ReceiptID