I’m trying to make a group consisting of everyone that would be included in a traditional register style descendant report, and the “Descendants and Spouses” option is not quite it since what is really needed is “Descendants, Spouses, and Parents of Spouses” since fully realized descendant reports indicate the parents of who the descendant’s children married. Is there another to way make such a group? Similarly it would be good to have the POS option attached to “Ancestors and descendants of ancestors”. The collateral lines doesn’t do it since it grabs the bulk of the tree.
There is not really an easy way to do it. You would have to chase down all the parents of the spouses one at a time.
Here is how I would do it with SQLite. First of all, I would go to a new color set that I hadn’t used before and use RM to color code the descendants and spouses as you describe. For example, I might choose red. Then I would write a very simple SQLite script to color code the parents of red people who didn’t yet have a color. For this color coding, I would use a different color - say green. The reason for making sure the people to become green didn’t yet have a color was to make sure some of the red people didn’t turn green by accident.
So there’s your group - anybody is color coded red or green in the new color set. The step that’s not possible in RM itself is “parents of red person and where the parents don’t yet have a color”. And the core of the problem in RM is the inability to search based on “parents of”.
3 Likes
The ability to search and filter by Relate1 & Relate2 fields (without needs for sqlite) would be welomed, (these fields are already in the person table). As well the the text of relate (2nd Uncle etc or 3x Cousin 3x removed etc).
Kevin
Thanks for the SQLite color code tip. I got this to work.