I'm working in Access 97 on an equipment tracking database and have the structure ironed out pretty well. On the left side of my main data viewing form I've added a treeview control using the treeview control wizard from Microsoft's site that shows all the Locations as Primary Nodes and the names of the Equipment in those locations as child nodes. "Locations" is a small table with the location name field as the primary key utilizing a one to many relationship with referential integrity with the Equipment table's "Location" field. The wizard set up everthing that you see pretty well...just nothing you'd need to DO.

I've been trying to figure out how to do a few things:

Assign unique icons to each child node based on what the piece of equipment is. (i.e. based on the Equipment Table's "Catagory" field, monitor icon for a monitor, cpu icon for a cpu, etc.)

Have information on the right side of my form change to show more detail (serial number, tracking number) based on what piece of equipment is selected in treeview (This could be in a listview control, or with regular form controls based on the Equipment Table's fields)

Enable drag and drop so I can move pieces of equipment from one place to another and have this action update the database.

Enable renaming of locations that whould also rename the corresponding location in the Locations table.

I've looked all over the net and the treeview control is not that well documented when trying to use it to view and manipulate database information in Access.

Any help on any of these points would be greatly appreciated.

~Hank