In Access, the Customer Table is the one side of the relationship and Orders is the Many. The link is made by dragging from Customer.CustomerID (the Primary key) to Orders.CustomerID (the Foreign key)- this is a one-to-many link.
In PowerPivot the link is shown going from Orders.CustomerID to Customer.CustomerID.
Am I right in saying that in PowerPivot you have to think about creating a LOOKUP, rather than re-creating exactly, the existing links? It's confusing! I hope I'm making sense!
Hi Moira,
Yes, in Power Pivot you drag from your fact table to your lookup table (dim table). Just as though you might write a VLOOKUP formula in a new column in your fact table to find the related column in your dim table.
Don't forget when bringing data in from Access and other relational databases you can bring in the relationships too, that way you don't have to add them again later.
Mynda
