Is there a way to create a supervisor hierarchy drill down with these fields.
NodeLevel | Name | ParentID | ParentName |
---|
1 | Board | null | null |
2 | Smith | 1 | Board |
2 | Johnson | 1 | Board |
3 | Byrd | 2 | Smith |
3 | Thomas | 2 | Smith |
3 | Manning | 2 | Johnson |
4 | Brady | 3 | Thomas |
4 | Flacco | 3 | Thomas |
4 | Jones | 3 | Thomas |
4 | Wentz | 3 | Manning |
I want a drill down to branch out like an org chart.
Is this possible with this data? If not what data could make this possible?