*Brothers marrying sisters

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
RobertW
Silver
Posts: 5
Joined: 27 Jun 2016 03:36
Family Historian: V6.2

Brothers marrying sisters

Postby RobertW » 09 May 2019 01:04

There are two brothers George and Harry in one family and there are two sisters Sarah and Mary in another family. George marries Sarah and Harry marries Mary. I am hoping there might be a query which allows me to search for this occurrence.

Gowermick
Megastar
Posts: 704
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Brothers marrying sisters

Postby Gowermick » 09 May 2019 05:58

Offhand, the only way I can think of, is to create a common note explaining the circumstances, then link the note to each of the individuals concerned ,a simple query could then list everyone linked to this note.

PS a similar solution could be applied to twins. Rather than set a “One of Twins” flag (as I have done :D ), a neater solution would be to create a common note to this effect, and link this note to each individual it applies to.
I say neater, because notes are usually more visible than flags!
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
Jane
Site Admin
Posts: 7615
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Brothers marrying sisters

Postby Jane » 09 May 2019 08:26

As an aside you can detect twins with an expression. Knowledge Base > Find and Mark Twins (How To)

one sibling pair marrying another is not that unusual I have a couple in my own tree.

You could query checking each of the relationships for
"wife's sister's husband" and "brother" on the same record.

If you want to scan the whole file you would probably need to write a plugin.
eg For each record, build a list of Wives and Siblings for the record and any wives and then compare the lists looking for married couples between the lists.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
tatewise
Megastar
Posts: 15902
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Brothers marrying sisters

Postby tatewise » 09 May 2019 09:13

Regarding twins see Twins (6606) that offers expressions for use in Diagrams and Individual Queries to find any twins, triplets, quads, etc.

Regarding siblings marrying siblings, use an Individual Query with a Rows filter Expressions such as:

=IsSameItem(Field(Individual(NextSib(%INDI%,1)),'INDI.FAMS>'),Field(Individual(NextSib(%INDI.~SPOU>%,1)),'INDI.FAMS>'))

=IsSameItem(Field(Individual(PrevSib(%INDI%,1)),'INDI.FAMS>'),Field(Individual(PrevSib(%INDI.~SPOU>%,1)),'INDI.FAMS>'))

=IsSameItem(Field(Individual(PrevSib(%INDI%,1)),'INDI.FAMS>'),Field(Individual(NextSib(%INDI.~SPOU>%,1)),'INDI.FAMS>'))

=IsSameItem(Field(Individual(NextSib(%INDI%,1)),'INDI.FAMS>'),Field(Individual(PrevSib(%INDI.~SPOU>%,1)),'INDI.FAMS>'))

Those cope with adjacent married siblings where the siblings can be in either order.

To cater for siblings who are not adjacent will need more expressions with nested NextSb(,,,) and PrevSib(...) functions such as:

=IsSameItem(Field(Individual(NextSib(NextSib(%INDI%,1),1)),'INDI.FAMS>'),Field(Individual(NextSib(%INDI.~SPOU>%,1)),'INDI.FAMS>'))

but the quantity required grows exponentially, and the problem would be more easily solved with a Plugin.

Once you have found such relationships, whether twins, or sibling marriages, you could add the Individuals to a Named List for future reference.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
DavidNewton
Superstar
Posts: 447
Joined: 25 Mar 2014 11:46
Family Historian: V6

Re: Brothers marrying sisters

Postby DavidNewton » 09 May 2019 15:28

Just a passing comment: would the second level relationship pull out this information. I have only one similar instance in my tree where a sister and brother married a brother and sister. The second level relationship reads 'Thomas --- is husband of sister of husband of ---'
David
Added in edit. I was thinking in terms of a plugin not a query

RobertW
Silver
Posts: 5
Joined: 27 Jun 2016 03:36
Family Historian: V6.2

Re: Brothers marrying sisters

Postby RobertW » 10 May 2019 00:55

Thanks for the responses. Jane and Mike Tate have helped me to understand the complexity of the issue. Since it occurs quite rarely, and you are almost certainly aware of it when initially entering the data, i think something like Mike Loney's solution would work for me.


Return to “General Usage”

Who is online

Users browsing this forum: Bing [Bot] and 7 guests