While it is possible to create multiple relationships between tables, only one of them can be active at a time. A classic example of this is where you have several dates in a data table, all of which are related to a single date in a date table. In the example shown in Figure 6-2, we have two date fields in the Sales table, both of which are joined to the Date table. The active relationship shown here is between the Date[DateKey] and Sales[SalesDateKey] columns:
Figure 6-2: Multiple relationships between tables with active relationship highlighted
Figure 6-3 shows the second relationship between the Date[DateKey] ...
