Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my databases I have columns like Org1ID,Org2ID,Org3ID,Org4ID,Org5ID at back end script I want to combine all columns make it has hierarchy , can any one help me out to do this Plz.
Thanks in Advance...
Hi Rish,
Can you elaborate on what is it exactly you're trying to achieve?
I have columns like this
Org1ID,Org2ID,Org3ID,Org4ID,Org5ID instead of creating hierarchy at frontend , I want to create those Columns come under one hierarchy columns at back end script
maybe you could create a concatenated field like
LOAD *,
Org1ID&'/'&Org2ID&'/'&Org3ID&'/'&Org4ID&'/'&Org5ID as OrgID
From YourSource
and use a listbox with the "Show as Tree View" option enabled (using / as separator)
hope this helps
regards
Marco
Hi Marco,
I found this method to be incredibly useful and visually, it created what I need but in doing so, I've found that none of the fields are selectable. The entire box is just grey. Any ideas?
My table structure is of a similar build to the original post creator's.
EDIT: The only selectable field is the lowest level.
Hi,
maybe helpful:
create a list box as TreeView having only complete dinamic path of a document
regards
Marco
Hi,
This unfortunately did not work. In those links, the user assumes that their hierarchy is already somewhat built.
For my case, it's like:
Level5, Level4, Level3, Level2, Level1
If I use your suggestion above, only the lowest level is selectable. Trying to have it such that all levels are selectable.
please post a sample application to demonstrate
Hi,
Re: How to create a listbox hierarchy from a table with many columns?
I posted everything in full detail here.