Create a Relationship

What Do You See? When you link two Tables by a common Field Microsoft Access will look for a relationship. Are these two Tables related? Yes, we want to link the Movies to the Rental Price.

 

If Microsoft Access does not detect a relationship between the Fields, you will be asked if you like to create one.

 

3. Try This: Create a Relationship

Click Yes. Keep going.

 

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Use Primary Keys to Create Relationships

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