Trees


Two related problems
1) Finding all names in a selected person's tree
2) Count Trees

1) Finding all names in selected person's tree
Does anyone have any idea how to emulate the function that is in the RM Mark Group of "Everyone in the highlighted person's tree"? RM does this very efficiently/quickly.I break the relationship between parents and then use it to create groups of maternal and paternal lines. It works ok, but would be a lot more efficient if I could automate it using SQL.

This produces a subset of the full tree; not the solution... (Tom, May 8)

2) Count Trees
I sometimes forget about this function, but it is very useful in finding orphans

Hopefully I did this right. Thanks in advance
marc