Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

Add the Data Fields

All queries need data output. Add the following fields to the grid:

 

From tblMovieRented:

ReceiptID

DateRented

 

From tblRental:

Price

Description

 

From tblCustomers:

LastName

FirstName

Address1

Address2

City

State

Zip

Phone

 

From tblMovieTitles:

Movie