Data Trees in Portals

[Tonydude]

Hello

I

[BobWeaver]

It depends on what kind of things you want to do, but normally each node is a separate record with a relationship from the child node to the parent node (within the same file) and vice versa. In this way you can create trees of any depth.

So far so good. You have the data in the database in a tree format. But, now if you want to display all the nodes for one tree, it's not so simple. My method is to use a combination of a calculated field that concatenates the node data from the current field onto the data from a look-up field that points to either the child or parent record. You have to perform a script that performs at least N look-ups in a row to propagate the data (where N is one less than the depth of the deepest tree). This will show all the data. But, it may not be in a format that you want.