organize data in tree structure in Access 2000

[Guest]

I have two fields in a table :"Line of Business" and "Parent Line of
Business". I want to organize the data in a tree structure and display it in
Access 2000. I would also like to select the relevant "Line of Business" from
this tree.

How do I do it?

Please let me know. Thanks.

Regards
Mitesh

 

[Rob Parker]

If you're comfortable with VBA coding, try the Treeview control. If it's
installed (and it almost certainly will be if you've got MS Office 2000, and
possibly from earlier versions), you'll find it in the Additional Controls
list from the form design toolbox.

For some initial hints on how to use it, check out Helen Fedemma's site:
http://www.helenfeddema.com/access.htm
particularly in the Access Archon section, numbers 53 and 103. The MSDN
site can also be useful.

Be warned: using the treeview controls is not particularly intuitive, and
you will need to get seriously involved in coding. If that's not your
thing, then don't go this way. If it is, a treeview control can be a very
good user interface.

Rob