~If you want to recursively traverse the BOM you may need a CTE query?~

[utaylor (Utah Taylor)]

Nice Ken, thanks for sharing.