Link the SOOrder table with DiscountDetail table
In the schema builder on the report Designer, how could we link the SOOrder table with the DiscountDetail table?
This for the Sales Order report, and I'm trying to display some of the Discount Details fields on the report.
I just cant figure out how to build a relationship between the two tables.
Try joining SOOrder to the SOOrderDiscountDetail on OrderType and OrderNbr.
Here is an example from a subreport that we use to display the discounts in a report footer.