Hierarchy in a List Box

[danialier]

Hello,

I have a List Box as follows:

A

B1

B2

C

D1

D2

D3

E

I want the list box to show a hierarchy as follows:

A

B (must be the sum of B1 and B2)

    B1

    B2

C

D (must be the sum of D1 and D2 and D3)

    D1

    D2

    D3

E

How I can do that ?

Thanks,

dani

[Nicole-Smith]

First you need a hierarchy load like the following:

OrgHierarchy:

Hierarchy (HierarchyOrgId, HierarchyOrgParentOrgId, HierarchyOrgName, ,  HierarchyOrgName, OrgTreeView)

LOAD OrgId as HierarchyOrgId,

    ParentOrgId as HierarchyOrgParentOrgId,

    Org as HierarchyOrgName,

    OrgId

RESIDENT OrgTable;

Then you can use the OrgTreeView field in a list box and choose to Show as TreeView: