BOM explosion inquiry/subfile

I am working on a project where I need to start with the planning BOM #
and work my way all the way down the tree. I need to display this
information in a subfile where the user has the ability to position by
component and several other fields. I have a working subfile where all
the parts are listed in a tree function and it works, but I built the
process in batch using a recursive called program. The key for the file
is the parent and then the level. If I add a logical by the child item
then I destroy my tree structure thereby making the inquiry useless. Has
anyone accomplished this because I know that we are not the only shop
that needs to see the structure like this.

 

Thanks,

Daniel