Is it possible to sort a multilevel hierarchy table (like bill of materials) that has a partID, parentpartID and level field with just a query?
So let's say i have a main assembly on top, then it has its subassemblies and parts in level 2, subassembly in level 2 can have other subassembies or...