How to sort a hierarchy?

[#1]

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?

[swuehl]

Maybe have a look at

Bill of Materials