Chapter 35: Introducing Power Pivot
35
FIGURE 35.7
The Diagram view allows you to see all the tables in your data model.You can move the tables in the Diagram view around simply by clicking and drag-
ging their title bars. The idea is to identify the primary index keys in each table
and connect them. In this scenario, the Customers table and the Invoice Header
table can be connected using the CustomerID field. The Invoice Header and Invoice
Details tables can be connected using the InvoiceNumber field.- Click and drag a line from the CustomerID field in the Customers table to the
CustomerID field in the Invoice Header table (as demonstrated in Figure 35.8).
FIGURE 35.8
To create a relationship, you simply click and drag a line between the fields in
your tables.- Click and drag a line from the InvoiceNumber field in the Invoice Header table
to the InvoiceNumber field in the Invoice Details table.
At this point, your diagram will look similar to Figure 35.9. Notice that Power Pivot
shows a line between the tables that you just connected. In database speak, these
are referred to as joins.