|
Both the
Table and Query have the same Key: CustomerID. We can create an ad
hoc relationship between the Table and the Query, a JOIN.
2.
Try it: Create Ad Hoc Relationships Go to
tblReceipt. Select a
Field: CustomerID. Drag
CustomerID to the Query, CustomerNameSQ and drop it on the matching
Key, CustomerID. What Do
You See? There should be a JOIN between the Table and the Query.
Now, if we have a CustomerID in tblReceipt we can look up the name,
address and phone that goes with that CustomerID. Keep
going...
Query Tools ->Design->Query Type->Select
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.2. Manage source tables and
relationships: Create Ad Hoc Relationships
|
|
| |
