Thanks very much for this method! I never would have thought of this way of doing a hierarchy.
I have an enhancement.
If you have more than 20 records or so the display performance becomes . . . ghastly. The culprit is the cAncestorIDs field definition.
if you change the field definition from:
List (
Parent::cAncestorIDs ;
ParentID
)
to:
if (ParentID ≠ "";
List (
Parent::cAncestorIDs ;
ParentID
);
ParentID)
You will get a colossal speed increase: Importing 300 records with the original definition was more than 5 minutes; after the change, 10 seconds or so. Display performance is now really quite acceptable. %^) Before, the list function was executing every time the record was touched and list functions are expensive.
Thanks again for the method!
Dave
