Add Fields to the Query
3.
Try it: Add Fields to the Query
From
tblReceipt select the following Fields:
ReceiptID
CustomerID
DateRented
From
CustomerNameSQ select these Fields:
FullName
CityStateZip
HomePhone
Do
This, Now: Save the Query
Go to
File->Save.
Enter a
name: ReceiptSQ.
Click
OK.
Close
the Query. The Record Source for the Receipt Form is done.