* Parents of Spouse

[marilyn57]

Just wondered, if there is a way to do a column on a query for spouses parents who are not blood related, and not added to the tree. At the moment I have them written in the notes for birth, and have added that to the query I need it in. Just wondered if there was an easier way.

Any help would be appreciated,

Thanks, Marilyn

[tatewise]

The way to tackle this is to understand the difference between the FH definition of a Blood Relation and a Relation Pool.
This will lead to all Relations Missing From All Relatives Diagram.

A Blood Relation as included in an All Relatives Diagram is:

1. The Root Individual and any Direct Ancestor.
2. Any Direct Ancestor of any Spouse of any of the above.
3. Any Direct Descendant of any of the above.

Note that this omits any Spouse of 2 and their Ancestors and any Ancestors of 3.

A Relation Pool includes anyone identified above however indirectly related by marriage.

Usefully there is a function to identify both the above namely =IsRelativeOf() and =RelationPool().
So an Individual Query needs the following Rows tab filters:
Add if =IsTrue(RelationPool(%INDI%) = RelationPool(["Diagram Root"])) is true
Exclude if =IsTrue(%INDI% = Individual(["Diagram Root"])) is true
Exclude if =IsRelativeOf(%INDI%,["Diagram Root"]) is true

A prototype Query is attached.

[LornaCraig]

A Blood Relation as included in an All Relatives Diagram is:

1 The Root Individual and any Direct Ancestor.
2 Any Direct Ancestor of any Spouse of any of the above.
3 Any Direct Descendant of any of the above.

Mike, regarding your item 2: It is my understanding that although spouses who were not themselves direct ancestors are included, their ancestors are not. Am I wrong?

[tatewise]

Yes, on reflection you are correct, I think it should be:

1. The Root Individual and their Spouse and any Direct Ancestor of them.
2. Any Spouse of any of the above.
3. Any Direct Descendant of any of the above.

Note that this omits any Ancestors of 2 and 3.

Referring back to original request, it was for a Column to indicate Missing Relatives, which can be achieved using the following Column Expression based on the above Row filters:
=IsTrue((RelationPool(%INDI%) = RelationPool(["Diagram Root"])) and Not(IsRelativeOf(%INDI%,["Diagram Root"])) and Not(%INDI% = Individual(["Diagram Root"])))

If you give this Column the Heading Missing then it will say Y for anyone omitted from Diagram.

In all the above, if you always use your File Root & Spouse as the Diagram Root then replace every ["Diagram Root"] with FileRoot() above.

[marilyn57]

Mike, thanks for all the trouble you have gone to with the above information, but unfortunately you have lost me completely. Dont think I explained what I needed properly.

I am trying to create a column which lists the parents of spouses of say uncles, aunties, cousins etc., who are not direct ancestors. The parents of the spouses are therefore of no interest to me, except to say who they actually are. I have managed to find out how to have a column for spouses parents, but as they are not listed on the tree the column is empty.

I have now written the parents names in the notes for birth and added this as a column instead. Dont suppose there is a way to do a fact stating this information without putting them on the tree is there??

Thanks again Mike for all your trouble, I will keep that information for when I get a bit more clever with this programme, there is so much you can do with it.

[Jane]

Although you could create a custom attribute to put that information in, personally, I would simply add them as normal individuals, perhaps using a flag to mark them as no further research required.

[tatewise]

I agree with Jane, just add them as Individual Records as normal, but add a Note or a Flag to indicate no further research proposed. Then they can be included in Diagrams, Reports, Queries, etc, or easily excluded conditionally on the Note or Flag.

[marilyn57]

Thanks for all your help, I will try that way