Page 1 of 1
More Than One Wife in Query
Posted: 13 Nov 2012 14:01
by marilyn57
I have managed to do a query (I think) for ancestors of a certain person, and descendants (3 generations) of this same person.
One of the descendants has been married twice, and is currently living with the third person, (unmarried) Please can anyone tell me how to show these three people in connection with a descendant. At the moment it is only adding his first wife.
Any advice appreciated as I am trying to do a gedcom file to send off, for a tree to be printed, but I have to get these certain people first.
Thanks, Marilyn[confused]
ID:6584
More Than One Wife in Query
Posted: 13 Nov 2012 14:28
by tatewise
This is all to do with Data Reference instances of data.
For example for Census Events:
The 1st Census Event has Data Reference %INDI.CENS[1]%.
The 2nd Census Event has Data Reference %INDI.CENS[2]%.
Similarly for each family/spouse:
The 1st spouse has Data Reference %INDI.~SPOU[1]>%.
The 2nd spouse has Data Reference %INDI.~SPOU[2]>%.
The 3rd spouse has Data Reference %INDI.~SPOU[3]>%.
So your Query must have Row filters that include as many instances of family/spouse as required.
When using the Data Reference Assistant to compose these Expressions, it only ever provides the 1st instances.
You have to add the subsequent instances by adjusting the [index].
More Than One Wife in Query
Posted: 13 Nov 2012 14:38
by tatewise
On second thoughts, maybe in the Individual Query you are selecting the Rows tab and using the Relations tab at the bottom.
You have presumably ticked Inc. spouses of relatives bottom right.
This will give Spouses of blood descendants but NOT the Spouses of those Spouses.
The same problem afflicts All Relations Diagrams.
What is the exact relationship between the starting Individual and the Descendant with 3 partners?
More Than One Wife in Query
Posted: 13 Nov 2012 14:48
by marilyn57
Thank you so much Mike, that`s my first complicated query. (Well to me anyway!!!)
Marilyn
More Than One Wife in Query
Posted: 13 Nov 2012 14:52
by marilyn57
Just read your second post, Hopefully I have what I want now,I did do what you said in relations. I wanted just the spouse of blood relations, (not spouse of their spouse). The relationship of the person with three spouses to the root is son.
Thanks again[smile]
More Than One Wife in Query
Posted: 13 Nov 2012 14:54
by PeterR
Further to what Mike said above, you can add as many filters as needed like the following, to include spouses of spouses:

More Than One Wife in Query
Posted: 13 Nov 2012 15:23
by marilyn57
Thanks Peter, I will remember that for future reference.