Microsoft Access Forum

Access Forum

Genealogy Relationship Upload Images Link
Anthony Mitchell
7 months ago

Hello Richard, I am struggling at present with my Genealogy Database. I have been working on this project for a while now and it's growing slowly. What I want to do now is to print a Relation Report for each individual and an overhaul relationship report. In my database, I have set myself as the Home Person, and each person relationship is entered into the persons home page. I have attached a Powerpoint with a number of screenshots to hopefully explain my setup better.

[LINK REMOVED]

I am struggling with my Query to give the results I want, any advice would be very welcome, or point me in the right direction. My brain is not so sharp as it used to be and I do struggle with Access, but I love this software and Genealogy so am trying to combine my two hobbies but getting a bit long in the tooth now for this (Too much excitement I am 74 years old).

Richard Live Long and Prosper........

Richard Rost
7 months ago

Anthony, my site doesn't allow links to external files. Please use the Upload Images link at the top to post your screen shots as images here. Thanks.

Anthony Mitchell
7 months ago

Richard Rost
7 months ago

So you essentially want to pick one person and then show their lineage? All relatives or just their direct ancestors?

Anthony Mitchell
7 months ago

I want to generate a report for each person that shows that persons direct relationship to the home person, this report will be different for each person. I would like the report to be in the form of a list,
For example,

                                                        James Mitchell III 1769  1848
                                                              3rd Great Grandfather
                                                                           V

William James Mitchell 1803  1873
Son of James Mitchell III
V

Adolphus Sharp Mitchell 1850  1929
Son of William James Mitchell
V

Charles Mitchell I 1894  1967
Son of Adolphus Sharp Mitchell
V

Billy Mitchell I 1925  2015
Son of Charles Mitchell I
V

Anthony Paul Mitchell I 1947
You are the Son of Billy Mitchell

To be honest with you I do not know where to start, I started building a Query but could not complete it because I just did not know how to proceed. Any help would be appreciated, thank you in advance.

Anthony Mitchell
7 months ago

Direct ancestors

Richard Rost
7 months ago

That is going to be quite a piece of work. You're going to need to build a recursive algorithm to basically traverse the entire family tree to find the shortest route between two people. That would be a challenge even for me to program. I'll add it to my list for a possible future upgrade. But no... this isn't a simple task.

Richard Rost
7 months ago

I would start by going back up each person's family tree to see if they have a common ancestor. Then you'd have to come back down that common ancestor's tree until you find the shortest route to each. It's a complex problem.

Anthony Mitchell
7 months ago

Thank you Richard appreciate your comments, I have just learnt this "recursive" learnt or just trying to understand. I have made a query and it works, but only works for the home person.

On each person, home page I have placed a "Relationship to HomePerson" button, thus working ok for the home person but not everybody else.

Appreciate your help will keep working.

Anthony Mitchell
7 months ago

Richard Rost
6 months ago

I'll be doing a lesson on recursion soon.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Forum Comments