• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2533
  • Last Modified:

Draw a family tree?

Hi:
See the attachment
tblMembers contain several fields ,
ID, Gen(Member Generation), EmpName, FID(FatherID = point to the ID of the father in the same file) and Sex.
My question is how to draw a family tree from these fields.
The very first generation is always one person only, and the second generation and over, they could be a one person up to seven persons.
I have up to 10 generations.
So, the second generation, each person could have up to seven sons.
The therd generation, each person could have up to seven sons, and so on for all the next generations, up to tenth generation.
Please help.

Ask-How-To-Build-a-Tree.mdb
0
Mohammad Alsolaiman
Asked:
Mohammad Alsolaiman
  • 3
  • 3
  • 2
  • +2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
Actually  I have no problem with maintain data inside table
My problem is I need a suitable way to draw this big amount of growing up series of generations
I think about draw a plenty of labels controls , and name it G11, G12, G121, G122, G123 & and so on
And thru a loop may be I can fill in these labels with members names.
can u help with this kind of loop ? please
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You could, but why not just use a Treeview control?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
puppydogbuddyCommented:
See this link for a working example of one way you can do it in ms access:
            http://www.fabalou.com/Access/General/genealogy_example.asp

Hope this helps.
0
 
puppydogbuddyCommented:
This is your lucky day:
           http://25yearsofprogramming.com/msaccess/famhistmdb.htm

0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
What I really need is to draw a real tree like shape, and fill it with my data.
My program fill in the members data very will in the tables, but now I need to draw the tree please.
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
watch the photo please
Alhaseenah-Tree.jpg
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Access includes some methods to draw basic shapes like Lines, Squares and Circle, but you're looking for something more high-end than this. You'd probably be better off in another environment like .NET that could use your Access data and draw something like this.
0
 
puppydogbuddyCommented:
Here is something that might help:
This link offers a free download of your Family Tree Chart "form" in pdf format. You can output any access report to pdf.  The only thing I don't know is how the report would be mapped to the pdf form.  That is something you can find out.

            http://www.misbach.org/pdfcharts/
Your Tree chart format is about the third format shown on the web page.

Hope this helps.
0
 
GRayLCommented:
Why not buy a Family Tree application.  There are lots around.  One thing to be aware of, these apps export and import data using the  Gedcom  format or the like.  To get your Access data into one of these apps which can create a family tree requires that you export to a text file using the Gedcom format - not a trivial undertaking.  
0
 
GRayLCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now