Access: Screen Play Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

 

One to One

The Receipt you designed allows one customer to rent one video at a time. It is a one-to-one relationship. In the real world, one customer can rent several videos at a time.

 

In order to create a one-to-many relationship, you need to create a Form with a Subform.

 

The main form would be where you select the customer and the date.

 

The subform would be the list of videos this customer rented.