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.