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.

 

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Use Primary Keys to Create Relationships

Home ->Records->More->Subdatasheet->Subdatasheet