Flatten a BOM

[gpayne (Greg Payne)]

@richard_cj_gardner This thread has a few examples.

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)