i second that
its pretty simple and easy to implement. no recursion is a plus


On Dec 19, 12:21 am, --CELKO-- <jcelko...@earthlink.net> wrote:
> >> Ideas, thoughts, links to examples where this has already been done? <<
>
> Get a copy TREES & HIERARCHY IN SQL and look at the Nested Sets model
> for BOM. It will be much easier than what you are doing.