Create Dynamic Listbox based on Hierarchy

[Anonymous]

Hello,

We have certain hierarchy in place. For example Region >> District >> Territory.

What we planning here is, dynamic listbox should be created based on hierarchical levels, i.e. for separate listboxes for each Region District & Territory.

Levels can increased to 10th level.

Is there any way or approach to create dynamic listboxes.

Please Help

[MarcoWedel]

you could use the build in TreeView option of list boxes (properties/general tab)

Just create a field that contains the complete hierarchy e.g. like Region/District/Territory or use an expression in the listbox like =Region&'/'&District&'/'&Territory.

The defined seperator has to match the seperator used to create the field values (here: '/')

hope this helps

regards

Marco

[tresesco]

Have a look at hierarchy prefix, it would create multiple Nodes dynamically.

[Anonymous]

Thanks for reply guys. I am able to achieve this.

What i want here is creating dynamic listbox.

If in hierarchy there are 3 levels then 3 Listbox should be display and so on....

[MarcoWedel]

maybe this could be the solution?

=SubField(Hierarchy, '/',3)

=max(SubStringCount(Hierarchy,'/'))+1>=3

hope this helps

regards

Marco