2 hours ago: I made a few modifications to the website yesterday so if you see any JavaScript errors let me know. Thanks.  Dismiss
 
Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Access
Back to Access Forum    Comments List
Genealogy Relationship Upload Images   Link   Email  
Anthony Mitchell 
3 years 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
3 years 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
3 years ago

Anthony Mitchell
3 years ago

Anthony Mitchell
3 years ago

Anthony Mitchell
3 years ago

Richard Rost
3 years ago
So you essentially want to pick one person and then show their lineage? All relatives or just their direct ancestors?
Anthony Mitchell
3 years 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
3 years ago
Direct ancestors
Richard Rost
3 years 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
3 years 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
3 years 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
3 years ago

Anthony Mitchell
3 years ago

Richard Rost
3 years ago
I'll be doing a lesson on recursion soon.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/22/2024 2:03:10 PM. PLT: 0s