Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Forums > Access
Access Forum

Back to 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.


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

Anthony Mitchell
7 months ago

Anthony Mitchell
7 months ago

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

William James Mitchell 1803  1873
Son of James Mitchell III

Adolphus Sharp Mitchell 1850  1929
Son of William James Mitchell

Charles Mitchell I 1894  1967
Son of Adolphus Sharp Mitchell

Billy Mitchell I 1925  2015
Son of Charles Mitchell I

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

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

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

5/27/2022Add Anything
5/26/2022List Items Edit Form
5/25/2022Column Colors
5/24/2022Multi-Table Forms
5/21/2022Access Developer 39
5/21/2022Access Developer 39 Lessons
5/21/2022Access Developer 39
5/21/2022Select Items in Related Table
5/21/2022Clear List Box

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn