Help with Treeview

[markclinn]

I am new to VB and need some help with treeview.

I am looking for something like windows explorer where you can have an infinite number of folders under any folder. I plan to use this tree to show a connectino path.

With the database, I can record which parent a device goes to, but for the treeview, it seems I need to know the child. I can create a table that crossreferences these items, but they can be changed at any time.

Can someone point me in the right direction?

Thanks

[Killer42]

...I can record which parent a device goes to, but for the treeview, it seems I need to know the child.

I don't think that's correct. When you create a node, you specify the parent of the new node. When accessing nodes, you have properties which return parent, children or siblings.

[nasiriqbal]

[hi this is nasir sending u a solution fron tree view

Set rs_gl = db.OpenRecordset("SELECT gl_code, gora,gora & ' - ' & gl_code & ' - ' & gl_name AS " _
& " acc FROM glmas ORDER BY gl_code")

Set rs_link = db.OpenRecordset("select * from table name")

Do While Not rs_gl.EOF
rs_link.FindFirst "ac_code=" & rs_gl!gl_code
If rs_link.NoMatch = False Then
Set Node1 = TreeView1.Nodes.Add(, , "Code" & rs_gl!gl_code, rs_gl!acc, "chkon")
Else
Set Node1 = TreeView1.Nodes.Add(, , "Code" & rs_gl!gl_code, rs_gl!acc, "chkoff")
End If

rs_gl.MoveNext
Loop