Before You Begin:
Draw A Data Diagram
Databases
use a Form with a Subform to create a one-to-many relationship.
The
Receipt Form has two Forms, two Tables, two Combo Boxes and three
links. This is a good place to make a data diagram.
Form:
Receipt
Record
Source: ReceiptSQ
Default
View: Form View
Phone
Combo: CustomerPhoneSQ
Form:
ReceiptSubform
Record
Source: tblMovieRented
Default
View: Datasheet
Parent and
Child Links:
ReceiptID
CustomerID
DateRented