Nesting parent-child levels

J

Jarde

I have the following table which contains product numbers. The first level
(0) is the main product (parent and child are the same). Upper levels are
sub-products, in which the child-columns make up the part whose number is in
the parent-column.

parent child level
------------------------
1075 1075 0
1075 2093 1
1075 90 1
2093 4927 2
2093 291 2
4927 735 3
4927 125 3

I am trying to make a report which shows what sub-products the product
consists of and correspondingly what sub-products those sub-products consist
of and so on.

The problem is that I need the output nested like this:

1075
|-90
|-2093
|-4927
| |-735
| |-125
|-291

And I don't know how to accomplish a nesting like that. Any help to get me
started would be appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top