how to create treeview in datawindow for data editing?

[Former Member]

Suppose I have table like:

mytree(id, parentid, ....)

It contains tree data with parent-child relationship. I want to maintain this data. There are 2 solutions:

Use treeview to load data from mytree table.

Use datawindow to populate data.

I want to UI can display data like treeview. Is it possible to use datawindow with trewview to allow user to maintain the data(add, delete, update)?

the treelevel is dynamic, could be any level. not only 2 level tree.

What's the best solution for this case?

[Former Member · Accepted solution]

Personally I would use a TreeView, then either

1. right mouse to a custom pop menu with add, change, delete items to a form datawindow in a small (maybe response) window which would retrieve and update to the database.  Or
2. use a preview window / area to the right of the treeview (a bit akin to scroll linkage in pfc)
   

Treeview items would have the primary key as data...

[Former Member · Accepted solution]

Thanks. Yes, I switch to treeview.