Page 1 of 1

Indirect relationship

Posted: 11 Aug 2022 16:28
by Gary Carson
Is there an expression that show indirect relationship(s) that could be used in a Query?

Something that is similar to indirect relationship(s) shown in the singular "How Related" Tool.

Re: Indirect relationship

Posted: 11 Aug 2022 17:36
by tatewise
Try the =Relationship(...) function or =RelationCode(...) function but I'm not sure how they can be used to identify direct versus indirect relationships.

Re: Indirect relationship

Posted: 12 Aug 2022 10:20
by Jane
You can check relationcode SPOUSE_START and SPOUSE_END to see if they are related by marriage or if you are looking for non blood relations why not use DnaRelatedness or DnaBloodRelation depending on what you are wanting.

They will be indirect if the DnaBloodRelation false

Re: Indirect relationship

Posted: 12 Aug 2022 14:54
by Gary Carson
The suggestions only returned blood relationships. I am looking for a query result similar to
Image

Re: Indirect relationship

Posted: 12 Aug 2022 15:14
by davidf
I don't think it can be done (at least in V6) because queries are "single pass" and to detect indirect relationships you in effect want to say:

"Run the query (1) past everyone in the database and identify all those related to Individual 1 (and how) and for each person identified run the query (2) past everyone in the database and identify all those related to Individual 2 (and how) and report how Individual 1 is related to Individual 2"

And alternative (possibly) is to repose the question and run a query to identify all who are mutual relations of Individuals 1 and 2.

So:
for all people
include if directly related to Individual 1
exclude if not (also) directly related to individual 2