Code:SELECT BKBMMSTR.BKBM_PARENT,
BKBMMSTR."BKBM_PROD_LINE^",
BKBMMSTR.BKBM_COMPONENT,
MTICMSTR.MTIC_PROD_DESC,
MTICMSTR.MTIC_PROD_SUBST_3,
MTICMSTR.MTIC_PROD_SUBST_4,
MTICMSTR.MTIC_PROD_SUBST_5,
MTICMSTR.MTIC_PROD_TYPE,
MTICMSTR.MTIC_PROD_VEND_1,
MTICMSTR.MTIC_PROD_CUST,
BKICMSTR.BKIC_PROD_DPTNT
FROM BKBMMSTR BKBMMSTR, BKICMSTR BKICMSTR, MTICMSTR MTICMSTR
WHERE BKBMMSTR.BKBM_COMPONENT = BKICMSTR.BKIC_PROD_CODE AND MTICMSTR.MTIC_PROD_CODE = BKICMSTR.BKIC_PROD_CODE
Can anyone tell me why this isn't working? If I create a PivotTable with
MTIC_CUST_CODE MTIC_PROD_CUST as the Report filter followed by the BKBM_PARENT Field as the first Row Labels, then select just 1 customer from
MTIC_CUST_CODE MTIC_PROD_CUST...
Basically I am hoping that I can choose a customer and it'll look through the item dB, and if the customer is part of that item it'll bring up the item's BOM
Any help appreciated.
Edit: See strikeouts above, my apologies for the confusion.