Create a Record Source
for the Receipt Form
The
Receipt Form will use a new Query that is based on tblReceipt.
However
tblReceipt is only numbers, so we need to look up the customer's
name and address in a Query, CustomerNameSQ, and link that to
tblReceipt by a common Key, CustomerID.
1.
Try it: Create a Select Query
Go to
Create ->Queries->Query Design.
What Do You See?
A blank query will open. The Show Table window will
prompt you to choose a Table or Query for the Record Source.
Select a Table: tblReceipt.
Click Add.
Select a Query:
CustomerNameSQ.
Click Add.
Click Close. Keep
going...