Make Another Relationship
8. Do This: Make Another Relationship
Manage Relationships is still open.
Click on New.
Enter the following when prompted.
Select a Table: tblProducts.
Select a Column: Specialty.
Select a Related Table: Table_tblSpecialty.
Select a Related Column: Specialty.
Click OK.
What Do You See? You will return to the Manage Relationships options.
There are two Relationships. tblProducts is related to two Lookup Tables.
The Management Relationships options include Edit, Activate, Deactivate and Delete.
Click Close to return to the PivotChart.
The next couple of pages look at managing these Relationships.
