Jump to content
TNG Community
beun.net

Report to show if ancestors of married couple were related...

Recommended Posts

beun.net

Some of the people in my tree who got married, appear to have (great)grandparents that are brothers or sisters.

In one specific case, there are two brothers. One of the two has a great grandson, and the other brother has a granddaughter.

This great grandson and granddaughter got married.

Is there a way to create a report that would show all married couples with ancestors that were related to each other?

Thanks :)

Share this post


Link to post
Share on other sites
beun.net

Let's give this old thread a "kick" :)

Share this post


Link to post
Share on other sites
svoght

No one? :o

I think you've got your answer.

The problem here is that SQL queries (which are really what TNG reports are) are limited in terms of being able to find ill-defined connections. They're great at searching for specific things (e.g. 'find all the males with the first name 'John' born between 1800 and 1900') but can't really do the sort of multiple-hop recursive searching you want to do here. If you had a more well-defined problem (e.g. 'find any individuals who share a parent') it would be easy. This is the same reason the TNG relationship calculator can't handle complex connections between people, and that's using PHP in addition to SQL queries, which enables a lot more recursive searching!

You might have better luck using dedicated desktop genealogy software to do your relationship calculations -- they've got the horsepower and design to deal with those sorts of complexities.

Share this post


Link to post
Share on other sites
beun.net

Didn't know this kind of query would be beyond MySQL.

Thanks for the explanation.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×