Create a Relationship with a JOIN Between Key Fields The CustomerNameSQ Query can be JOINED to tblMovieRented by a common Key: CustomerID.   7. Try This: Create an Ad Hoc Relationship Drag CustomerID from tblMovieRented to CustomerID in CustomerNameSQ.   And Try This, Too: Add More Fields Add the following Fields to the QBE Grid: From CustomerNameSQ: FullName CityStateZip HomePhone   Save, Save, Save. Keep going, please. Query Tools ->Design Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Manipulate fields: Add Fields to a Query