6 Replies Latest reply: May 4, 2012 5:25 PM by Stephen Charles RSS

Parent Child linking issue

Stephen Charles

The attached excel file shows the two tables to work from (Sales Order Head and Sales Order Detail) and the two report output I am looking for. Basically, the Sales Order Head table holds orders for both Quotes and Regular orders. The Sales Order Detail holds the detail line information. A field in the Sales Order Detail file will have a reference to the Quote order number if that line relates to the quote.

Can seem to generate the linking (preferably in a "Fact Table") that gives me all that I want.

Thanks for any help.

Stephen