Treeview assistance requested 2

[directorz]

Hello experts,

I’m stumbling with a treeview. I’ve created my first one and have it populated. I have difficulty in understanding how to associate the value that a node represents to a record…let me elaborate.

The db I’m working on focuses on periodic maintenance of cars. Maintenance schedules can be assigned to each car like preventive maintenance 'a'(PM-A) or preventive maintenance 'b' (PM-B) and so on. Each PM is broken down into intervals such as interval 1, interval 2 etc. So, for example, PM-A / Interval 1 might be items that occur every 3000 miles, PM-B might be items that occur every 6000 miles etc. This arrangement is represented by a treeview and it’s nodes:

PM-A
l
l
l---Interval 1
l
l---Interval 2
l
PM-B
l
l
l---Interval 1
l
l---Interval 2

While entering data in a form relative to a car, I can call the treeview. What I need to understand is how to associate or ’assign’ the value of a node, say interval 1, to that car. I would like to dblclick the node and have that value placed into the record of the car. Could someone assist.

Thank you

Directorz

 

[directorz]

FancyPrairie,
Are you receptive to assisting with a modification of treeview0. Everything's fine but I'm looking to expand it to show 'hours' 'days' and 'miles' as part of the intervals. I won't have a sample until tomorrow for you to look at.

Thank you in advance

Directorz