Link the Form Fields

Whenever you link the Master and Child Fields, you make the database fill in the blanks for you.

 

If you link the CustomerID, then whenever you select a customer from the Combo Box on the Master form, the subform will inherit the CustomerID.

 

There are three links: the ReceiptID, so that one receipt can record many movie rentals, the CustomerID, so that one customer can rent many movies, and the date fields.

 

Try it: Review the Property Sheet

Select the Subform.

Go to Design->Property Sheet.