hi there,
I'm would like for a custom query to show the generation number of the descendants of a group of ancestors, like '1' or '2' generations from the ancestors.
Do you know what expression I should enter into custom query to produce this result?
Thanks!
* Custom query expression for generation number
-
- Silver
- Posts: 5
- Joined: 19 Nov 2013 05:33
- Family Historian: V5
- tatewise
- Megastar
- Posts: 28335
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom query expression for generation number
Have a look at the functions =Relationship() and =RelationCode().
See Help > Search Help > Relationship Functions > List Topics for details.
However, I don't understand exactly what Generation number you want.
You mention "descendants of a group of ancestors" which is confusing.
If you choose one Individual, and list all Descendants, then their Generation number can be calculated with respect to the chosen Individual.
But if you choose several Individuals, and list all their Descendants, then they could have several common Ancestors and cannot determine which one to use to calculate a Generation number.
See Help > Search Help > Relationship Functions > List Topics for details.
However, I don't understand exactly what Generation number you want.
You mention "descendants of a group of ancestors" which is confusing.
If you choose one Individual, and list all Descendants, then their Generation number can be calculated with respect to the chosen Individual.
But if you choose several Individuals, and list all their Descendants, then they could have several common Ancestors and cannot determine which one to use to calculate a Generation number.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry