If you create a Hierarchy load like
Hierarchy (NodeID, ParentID, NodeName, ParentName, Pathsource, Path, '\', Depth)
NodeID & ' ' & NodeName as Pathsource,
you will get the path you want. Note the "Pathsource" field.
On the selections: If you make a selection of a node when it is expanded, you will select only the top node. But if you select a node when it is collapsed, you will select the entire tree. So, make the selection when the node is collapsed, and you will get what you want.
The reason why we have chosen to design it this way, is that it wouldn't be possible to select the top node only otherwise.
this worked very well. Thank you very much. Now that created a further question to me.
Would you please help me with that again?
I have to create two Hierarchies (called CODE D and CODE B). The Hierarchy in CODE D is now finished (thx to you again).
Now I want to create a Hierarchy of CODE B.
Problem is, that on TOP the Parent ID is the Bottom of CODE D.
(I know copied the complete Hierarchy of CODE D into CODE B).
But I wish to get a link between those two, because I dont want to have two identically databases.
o you have an idea?
Thank you very much in adcance