Hello,
I've some problems with my hierarchy table and hope you could help... I'll give you a quick example:
I've got a bom wich looks like this:
| Main | Sub1 | Sub2 |
|---|
| MainPart | a | |
| b | z |
| | x |
| c | |
| b | z |
| | x |
So I'm using the HierarchyBelongsTo Function and get something like this:
| ID | Part | Depth |
|---|
| MainPart | - | 0 |
| MainPart | a | 1 |
| MainPart | b | 1 |
| MainPart | b | 1 |
| MainPart | x | 2 |
| MainPart | x | 2 |
| MainPart | z | 2 |
| MainPart | z | 2 |
How is it possible to achieve a hierarchy wich actually showes how the bom is structured?
