By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Accessing hierarchies

P: n/a
Hi experts

I have a familyTree table which looks like this in MS Access 2000

id Name parent
1 A 0
2 A1 1
3 A2 1
4 A3 1
5 A11 2
6 A12 2
...................................
...................................

I can access only upto only level with a recursive relationship query.
How could it be possible to retrieve all the children and grand
children and so on upto n levels of a parent. The parent id should be
provided as a parameter for the query. Also another query should be
able to retrieve the parent, grand parent and so on upto level for a
child. The queries should also return a level field (calculated at
runtime, not stored in the database). Is it possible in MS Access.

Regards

Sajid
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.