TreeView of self referencing Table with Id and ParentId fields

Question

On a table or view with self referencing from ParentId field to another record’s Id field is there a way to display a hierarchical Tree view with expand or collapse icons to show or hide sub records and highlighted row then will allow edits in a child window for the detail fields of that record.

Answer 1

dbFront does not have any treeview capability.

dbFront can show self referencing tables (where the table has a foreign key to itself) and it will show the parent and the immediate child, but there is no treeview option to allow you to quickly see more levels.

It is also possible to create a Stored Procedure that returns the treeview structure as HTML and then you can use dbFront to display that to the user with a RunProcedure button.

Thanks for this request.

NOTE: Please vote on this Feature Request if it interests you.