More Than One Wife in Query

marilyn57 · Post by **marilyn57** » 13 Nov 2012 14:01

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

Post by **tatewise** » 13 Nov 2012 14:28

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].

Post by **tatewise** » 13 Nov 2012 14:38

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?

marilyn57 · Post by **marilyn57** » 13 Nov 2012 14:48

Thank you so much Mike, that`s my first complicated query. (Well to me anyway!!!)

Marilyn

marilyn57 · Post by **marilyn57** » 13 Nov 2012 14:52

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]

PeterR · Post by **PeterR** » 13 Nov 2012 14:54

Further to what Mike said above, you can add as many filters as needed like the following, to include spouses of spouses:

marilyn57 · Post by **marilyn57** » 13 Nov 2012 15:23

Thanks Peter, I will remember that for future reference.

Family Historian User Group