Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Create and Modify Relationships (Subdatasheet)

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.   Home ->Records->More->Subdatasheet->Subdatasheet