How do you go about joining three tables (lists)
CustomersList
----------------
CustomerID PK
OrdersList
----------------
CustomerID
OrderID PK
OrderDetailsList
----------------
OrderID
OrderDetailsID PK
It seem the current joining options makes a virtual star schema.
I tried to create a list based on joining the CustomersList and OrdersList ( called it CustomerOrders) then made a copy of CustomerOrders("Copy of CustomerOrder") and joined the OrderDetailsList, but that breaks fabrik because of primary key violation.
How would I go about joining three lists in the example above? Looks liek it restrected to just two levels of join, part to
CustomersList one---to--many<OrdersList one---to---many<OrderItemsList
Basically: One "customer" (CustomersList) can have "many orders" (OrdersList), one order can have "many items" (OrderItemsList)
Hopefully that make sense.
CustomersList
----------------
CustomerID PK
OrdersList
----------------
CustomerID
OrderID PK
OrderDetailsList
----------------
OrderID
OrderDetailsID PK
It seem the current joining options makes a virtual star schema.
I tried to create a list based on joining the CustomersList and OrdersList ( called it CustomerOrders) then made a copy of CustomerOrders("Copy of CustomerOrder") and joined the OrderDetailsList, but that breaks fabrik because of primary key violation.
How would I go about joining three lists in the example above? Looks liek it restrected to just two levels of join, part to
CustomersList one---to--many<OrdersList one---to---many<OrderItemsList
Basically: One "customer" (CustomersList) can have "many orders" (OrdersList), one order can have "many items" (OrderItemsList)
Hopefully that make sense.