Thaks for helping - I am attempt understand.

I will take step at a time

If I index on the table to show only parents
and only wanted to show one node for each parent

All Accounts
:
____ Parent 1
____ Parent 2

thisform.treeview.Nodes.Add(,4,ALLTRIM(code1),ALLTRIM(name))

Error reads: OLE Idispatch exception code 0 from Nodes Invalid Key

Leo