Indented parent child relationship

[motivatedgorilla]

I have the following table and i need to be able to present it an indented list of parent child relationship. The hierarchy can go 1000+ levels deep. How do i achieve this using VBA?

OName	OPackID	PPackID	PName	ParentID
Name1	556	556	Box1	389
Name2	420	420	Box2	402
Name3	301	301	Box3	671
Name4	409	407	Box4	402

<tbody>
</tbody>

If there is a better way of presenting it, it isn't limited to an indented list.

 

[mikerickson]

From that table, I can't figure out who is parent and who is child.

Also, can a parent have more than one child? Can a child have more than one parent?

 

[motivatedgorilla]

From that table, I can't figure out who is parent and who is child.

Also, can a parent have more than one child? Can a child have more than one parent?

Yes. A parent can have more than one child and a child is limited to a single parent. Sorry, i copied a subset of data from a workbook that has over 50,0000 rows.

 

[motivatedgorilla]

Also the root starts with the value 0

 

[mikerickson]

How does the chart indicate the parent child relationship?

 

[motivatedgorilla]

What do you mean? Do you mean the table?

An element with a name is assigned to a given pack, which has an id. The pack may either be a parent of the root or a child of another pack.