Page 1 of 1

Amend All Relationships query...

Posted: 04 Mar 2023 18:35
by fhtess65
Is there a way to amend the All Relationships query to add my husband's line as well? If so, would it involve creating a Group for my husband's line and adding it as Group 2? And would it figure out my relationship to his line?

Thanks :)

Re: Amend All Relationships query...

Posted: 04 Mar 2023 19:24
by tatewise
Yes, try the attached Query and if necessary add more Rows tab filters like the one that are there.

Re: Amend All Relationships query...

Posted: 04 Mar 2023 19:43
by fhtess65
tatewise wrote:
04 Mar 2023 19:24
Yes, try the attached Query and if necessary add more Rows tab filters like the one that are there.
Thanks, Mike - that worked...what did you add to include my husband's ancestors?

Re: Amend All Relationships query...

Posted: 04 Mar 2023 20:56
by tatewise
Compare the Rows tab filters between the standard All Relatives query and this custom variant.
It just adds some more Add if an ancestor/descendant of anyone in the current result set.

Re: Amend All Relationships query...

Posted: 04 Mar 2023 23:23
by fhtess65
Thanks :) I see now what you did. Trying to learn more about building custom queries. As always, I appreciate your help.
tatewise wrote:
04 Mar 2023 20:56
Compare the Rows tab filters between the standard All Relatives query and this custom variant.
It just adds some more Add if an ancestor/descendant of anyone in the current result set.