	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.8

Draw a Hierarchy family tree

Asked by M_SOLAIMAN in Voice XML, Microsoft Access Database

Tags: ms access 2003

Hi:
I need to build a Hierarchy family tree program(like windows explorer), but (top down expand).
I have the data In a table. This table contains
"the name",
"the unique name code",
"the name level",
" the related name code". (always relate to the father of this person(like foreign key but in the same table))
I need a function can read this table and draw the tree for me on a form, so each person will be represented by a box (his name will be inside this box), and there are a arrow join this person with his father (upper level), and another arrow join this person with his kids(down level), and by sides arrows to join the person with his brothers how's at the same level.
Take an example
(First level) The very first father is "A"
(Second level) He has a 5 kids, "B", "C", "D", "E", "F"
(Third level) "B" has 2 kids "B1" and "B2",
"C" has 3 kids "C1" , "C2" and "C3",
"D" has 4 kids, "D1" , "D2", "D3" and "D4",
"E" has 1 kid, "E1",
"F" has 0 kids.
(Forth level) "B1" has 1 kid, B1_1
"B2" has no kids.
"C1" has 3 kids "C1_1" , "C1_2" and "C1_3".
"C2" &etc
"C3" &etc
"D1" &etc
"D2" &etc
"D3" &etc
"D4" &etc
"E1" &etc
(Fifth level) "B1_1" has 1 kid, B1_1_1
And so on.
Can I do such thing in MS Access?
Please help!

View the Solution FREE for 30 Days

Related Solutions

Keywords: Draw a Hierarchy family tree

	Title
1	Trouble with Mail Forms
2	Captcha Error
3	Test Long Question Body
4	New window not wanted
5	How much will Bus Clock 100 mHz …

Loading Advertisement...

20091118-EE-VQP-93 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. Ray_Pas...6,000
2. press03,500
3. BigRat2,000
3. abel2,000
3. cxr2,000
3. Tiggerito2,000
3. sdwalker2,000
8. lherrou1,500
8. AlexieS1,500
8. sajayj20091,500
11. bhess11,400
12. kelvinsparks800
13. TextReport600
13. BillBach600
15. gr8gonzo500
16. tbsgadi450

1. Ray_Pas...6,000
2. dougday3,500
2. press03,500
4. daluu2,800
5. BigRat2,360
6. abel2,000
6. Gertone2,000
6. cxr2,000
6. Tiggerito2,000
6. sdwalker2,000
11. jawahar_...1,500
11. lherrou1,500
11. AlexieS1,500
11. sajayj20091,500
15. bhess11,400
16. EddieShip...1,200
17. apparition1,000
17. mshogren1,000
17. jaspreetsi...1,000
20. jlevie800
20. udnimbalkar800
20. kelvinsparks800
23. amit_g750
24. TextReport600
24. BillBach600

Draw a Hierarchy family tree

Asked by M_SOLAIMAN in Voice XML, Microsoft Access Database

Tags: ms access 2003

About this solution