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!
(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!