The attached image shows what I am trying to achieve.
In this scenario, Employees 2,4,5,6 & 7 report to Employee 1, and can be seen when I expand the + box at the left. This bit is working great as i can clearly see which employee has direct reports and who they are. My ONLY current need is to populate the LastName column in the header section of the grid.
How can I modify my code to make LastName, which comes from a Contact lookup entity, show up? As I said earlier, there is a 1 to many relationship between the Employee and Contact entities. For a give record in Employee, there can be several records in Contact, the first of which will have a contactType of 'Self'. Other records can be Spouse, NextofKin...........