Still very useful. I actually am looking for a better way to write my query that cycles through the BOMS. Here is what I currently have. The question is, given a top level assembly id (in this case 1402) give all the components of the assemblies and subassemblies.