Introduction to Power Pivot - Microsoft Business Intelligence Tools for Excel Analysts - page 51

Figure 3-8: When you create relationships, the Power Pivot diagram shows join lines between your tables.

Notice that the join lines have arrows pointing from one table to another. The arrow in these join
lines always points to the table that has the non-duplicated unique index.

To close the diagram and get back to seeing the data tables, click the Data View button
in the Power Pivot window.

Tip

If you need to edit or delete a relationship between two tables in your Data Model, you can do so by
following these steps:

1. Open the Power Pivot window. On the Design tab, click the Manage Relationships button.

2. In the Manage Relationships dialog box, click the relationship you want to work with and
then click Edit or Delete.

Clicking Edit opens the Edit Relationship dialog box shown in Figure 3-9.

Figure 3-9: Define the relationship by selecting the appropriate table and field names from the
drop-down lists.