* Indirect relationship

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

[tatewise]

Try the =Relationship(...) function or =RelationCode(...) function but I'm not sure how they can be used to identify direct versus indirect relationships.

[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

[Gary Carson]

The suggestions only returned blood relationships. I am looking for a query result similar to

[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