Displaying Hierarchical Links

[IGN_Mikey]

Hey guys. I currently have a list of data simply named Circles (as in a group or organisation). Most of my circles have a parent that is also a Circle.

I would like to find a way to visualize these relationships. The connections can go very deep so expanding a sub dataset isn't enough. They can only go 5 deep and it's not very visual, just a list.



Is there anything I can do in access forms to help my users to visualize these connections better?

[June7]

Sounds like recursive relationship structure - table is joined to itself. A family tree is one example.

Search web. Here is one http://www.tomjewett.com/dbdesign/db...=recursive.php

[CJ_London]

this link may help

http://www.access-programmers.co.uk/...ight=recursive