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)
7 Likes