Mohammad Alsolaiman
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could, but why not just use a Treeview control?
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.
http://www.fabalou.com/Access/General/genealogy_example.asp
Hope this helps.
ASKER
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.
My program fill in the members data very will in the tables, but now I need to draw the tree please.
ASKER
watch the photo please
Alhaseenah-Tree.jpg
Alhaseenah-Tree.jpg
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.
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.
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.
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.
http://allenbrowne.com/ser-06.html