What is the Plan? One customer may get many movies. So, the Receipt Form will have a Form and Subform. The Receipt Form will also use a Combo box to look up a customer by their phone number. The Subform will list the movies rented.   Create a Record Source for the Form The ReceiptSQ Select Query will JOIN the Receipt Table with a Query, CustomerNameSQ, that combines (concatenates) the name and address fields.   Create the Form: Receipt The Receipt Form will use a Combo Box to look up the customer's phone number and display their name and address.   That's the plan. Microsoft Office Access 2010: Example of the completed Receipt Form in Design View