Recursive Qry to simulate up/down (relate1 & 2)
Has anyone experimented to report the up & down from stating person ?
basically to replicate the relate1 & relate2 for up & Down using a Recursive Qry to simulate up/down (relate1 & 2)?
Yes and no.
The yes part if that my color coding script uses a recursive query to color code up from a starting person and then uses a second recursive query to color code back down.
The no part is that it is color coding only and it doesn't look at or modify the Relate1 or Relate2 or Flags columns. But the logic would be very similar to look at the Relate1 and Relate2 and Flags columns.
I have considered writing my own Set Relationships process because I consider the new one in RM10 to be so dysfunctional. If I did, I would use my color coding script as the starting point. But right now, I'm trying to do more "real genealogy" from the RM user interface and not be quite so focused on SQLite scripts.
Thanks.
I have a color scripting uses the Relate1 / Releate2 & flags -- its works well.
The issue is that it does not refresh when new people are added. I also use a view (well two actually) to facilitate things. Not sure if the 2nd works quite right but for my personal use it works okay.
My Colors are a bit different than you
- Orange for Aunt/Uncles
- Yellow for cousins
- different shades for Half Uncle or cousins
- same with spouse of Green or lime
- Siblings are purple and parents of spouse are light purple for examples