Access have table data field, name of commodity, classification, the parent for the classification of field data, the child as the commodity name, classification field data has a lot of repetition, in order to show that I use query is:
Rs. Open the Select a category from the data group by classification,,,,,,,,
For I=0 To rs. Recorcount - 1
The Set nodeindex=Treeview. Nodes. Add (,, "level" & amp; I, rs. Fields (classification), "tu1")
The parent can, according to the normal children don't know how to show according to the parent query, exclude please,