Many of my wider family lived in small isolated villages in the 18th and 19th centuries so it is not surprising that families frequently inter-married. My problem is that I find it impossible to present the information in a way that makes this clear. With any sort of ancestor chart, the inter-marriage is only apparent when I spot the same people turning up in two (or more!) places in the same chart. It would be nice to have a way of flagging this up automatically. At the moment I try to highlight these instances by colour-coding people who married a cousin, but I have to find the occurrence first.
In this example shown Robert Norman married his first cousin Martha Melhuish. Then his sister Jane married Martha’'s brother, so of course they were also first cousins. In the next generation it gets even more confusing because Robert and Martha’s son married John and Jane’s daughter. So this means that the happy couple were first cousins twice over, and second cousins twice over too! Moving on to the next generation, Mary Jane had 4 grandparents like we all do. But she only had 4 great-grandparents instead of 8. And she only had 6 great-great-grandparents instead of 16.
It would be nice to have a way of presenting these sorts of relationships clearly, either within Roots Magic or in some other way.
It is helpful. The chart with the swirly pink and blue lines is just the sort of thing I was looking for. In the next few days I’ll prepare a gedcom file and upload it, to see how it works out for my tree. Thanks.
I’ve gone through a number of iterations of the query with Gemini and have arrived at the attached script which is
some 30x faster than the original I reported,
more succinct by listing only the relationship via the Most Recent Common Ancestor(s)
more informative by including:
names of both MRCA’s when they are the family from which the cousin couple is descended
half-cousin relationships
number of children for each cousin couple
Here’s a sample output:
FatherName
MotherName
CommonAncestor
RelationshipDescription
NumberOfChildren
FatherGenerationsBack
MotherGenerationsBack
total_generations_back
Wyatt Wxxxx-1476
Sarah M. A. Exxxx-1472
Joseph Bxxxxxx-911=Sallie Jxxxx-912
Full First Cousins
0
2
2
4
David Dxxxxx Bxxxx-6512
Mary Bxxxx-440
David Bxxxx-62
Half First Cousins
0
2
2
4
Abraham Pxxxxx-25237
Dixie Axxxxx-27989
Archibald Pxxxxx-5955=Malinda Axxxxx-5951
Full 1th Cousin 1 time(s) removed
7
2
3
5
On a RM10 database having ca 17,000 couples in its FamilyTable, the query returned 294 results in under 9 seconds. The query should work on all versions of RM databases from RM4 to RM10 but has been tested only with RM10 databases.