dkmornie posted on June 7, 2012 at 9:52 am

I have a database with a number of columns e.g. id, parentid, name, title
Data could look like this
id: 1, parentid: null, name: John Smith, title: CEO
id: 2, parentid: 1, name: Susan Jones, title: Sales manager
id: 3, parentid: 2, name: Scott Mark, title: Sales assistant
id: 4, parentid: 1, name: Helen Sun, title: Account manager
id: 5, parentid: 4, name: Mark Lie, title: Account assistant

What I want to achieve is a tree functionality but just in a grid.
The result should look something like this:
- John Smith CEO
– Susan Jones Sales manager (2nd level)
– Scott Mark Sales assistant (3rd level)
+ Helen Sun Account manager

The title should be a link.