Subdatasheet Options
A
Subdatasheet can be a Table or a Query. The Subdatasheet will use
the Primary Keys to create a one-to-many relationship.
2. Try
This: Insert Subdatasheet
Select a
Table: tblRentalPrices
Link Child
Fields: RentalPriceID
Link
Master Fields: RentalPriceID
Click
OK. Keep going.
Memo to Self: Microsoft Access
will immediately look for a relationship between the Fields. A
rather large pop-up with a red X may appear- pictured on the next
page. This is not a mistake, although it may be startling the first
time.