Bom baq based on view as assembly in method

[gpayne (Greg Payne)]

This thread has a exploding bom query. I don’t know how to factor in the view as assembly in the CTE.

Build BOM in Query

This CAN be done… but it takes a RECURSIVE (CTE) BAQ. I have demoed this in the past at user group meetings. Note that this is NOT something for the faint of heart… your brain gets twisted while trying to get your head around a CTE query. BOM_Explode.baq (72.8 KB) Recursive BAQs.pdf (983.2 KB)