[Originally posted by kev]

Hello to all,


Here is a flat customer table

Before
===================
CustId Po# Last First Phone
-------------------------------------------------
101 12 don Joe 233-3333
101 13 Engish Errol 333-2322
101 16 Santiago Eddi 565-4443

104 56 Long Jimy 675-4333
67 Long Erol 567-3333
104 34 Creek Darson 567-3322

105 67 Eddit Mark 987-2333

107 34 Grant PRice 655-3333


After in a TreeView
====================

List of Customer

101
12 don Joe 233-3333
13 Engish Errol 333-2322
16 Santiago Eddi 565-4443

104
56 Long Jimy 675-4333
67 Long Erol 567-3333
34 Creek Darson 567-3322
105
67 Eddit Mark 987-2333
107
34 Grant PRice 655-3333


Notice: a blank in CustID -->104


Assume I have my recordset, now I need to fill
the TreeView with these data.

How do you loop thru the recordset and populate the treeview with these data. Somethimes
be a blank in CustId.

Thanks