I have 3 Tables
1. Sales - > Having Order#, Line#, SKU1, SKU2, Plant#, OrderQuantity - (consider SKU2 as substitute item for SKU1)
2. Item Master - > Mat#, SKU# (mapping is available for Mat1 to SKU1 and Mat2 to SKU2 in this table),
3. Inventory Table - > Mat#, Plant# , Avl Qty
Using Association without using script is there a way to view
Order # , SKU1, OrderQuantity, Avl Qty (for SKU1) , SKU2, Avl Qty (for SKU2)
