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...

Create ->Queries->Query Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships: Use the Show Table command