4 tier treeview

[NigelShaw]

Hi

I was hoping that somebody might be in a position to help me for a change

Trying in vein to work out a treeview but there are so many different ways to do it.........

I need a 4 tier treeview. I wondered if the best was to have 4 tables as there can be many items per treeview item or just use 1 table? Example

4 main items in the tree
Each item has 6 sub items
Each sub item has 10 sub items
Each sub sub items have 2 items

Or in other words (a typical full tree)

1. Workshop
.......|______2. Material
.......|..........|_______3. Wood
.......|..........|................|______4. Tulip
.......|..........|................|______4. Oak
.......|..........|................|______4. Pine
.......|..........|_______3. laminate
.......|..........|................|______4. polyrey
.......|..........|................|______4. print
.......|______2. Labour
...................|_______3. office
....................................|______4. managment

Another reason was I wanted the ability to add treeview items by code.

Some examples I've seen have only 1 table with tier numbers which all looks a bit confusing.

Is anyone feeling generous enough to help me today?

I'd be very grateful if there was


Cheers

Nige

 

[jdraw]

Nigel,

There is a blog by Stephen Hill
http://mymsaccessblog.blogspot.com/2009/03/access-treeview-listview-basics-from.html that goes step by step thru treeview with examples and downloadables.

I haven't used it for a year or so, but it was a great help.

All episodes are reachable from here
http://mymsaccessblog.blogspot.com/2009/03/my-treeview-project-episode-6-images.html

 

[NigelShaw]

Hi J

Thanks for the link. Took about 1/2 hr through the tutorials but now I have just what I needed.

Cheers

Nigel

 

[NigelShaw]

Hi

As an update, treeview is completely updatable and dynamic now and I made a splitter bar with save positions. I added buttons to expand, collapse and open main sections only, grey out any items not relevant and a dynamic filter to show only the selected main tree.

The only one part im struggling with is the drag drop. I can get it to show it dragging but don't know how to make it update the table.

N

 

[jdraw]

There is a drag and drop example here.

I dragged Operations/Support to Mississippi/Land /Documentation and it updated the Table.

http://www.utteraccess.com/forum/Treeview-Sample-Drag-Dr-t1962587.html