I have a self join setup that is of a parent-child relationship. With some of the records, there are multiple level parent-child relationships. What I'm trying to achieve is to get a list of parent-child-grandchild, etc. Using a portal I can achieve the first relationship but haven't been able to figure out a good way to get the entire tree of relationships.

Eventually I will need to get a count based on a quanity field of the children and grandchildren but first things first.

I used FileMaker fairly extensively with 5.5 but haven't in several years and am new to 7 so I haven't worked all the news features out yet.

In order for the grandchild to show in the relationship, it must have the ParentID as part of the grandchild's match field, probably in a multi-key. To show all decendants in the relationship, each node must have all IDs for its parents, grand parents, etc., as part of the multi-key.

This is the same kind of structure that is used in hierarchical menu portals. I think Ugo had a good demo of this somewhere. Though it was made in FM5/6, the concept is the same for FM7.