Another Tree View Issue

Jhstephenson · Post by **Jhstephenson** » Thu Mar 03, 2022 5:59 pm

I have an odd issue on using a Tree Widget.

Here is the setup.

I have an Employee table that has an attribute called EmployeesSupervised. You can add as many employees as might be needed to each EmployeesSupervised attribute. So, if I am an employee, I could supervise Mickey Mouse who could in turn supervise Minnie Mouse who could in turn supervise Goofy, who supervises Pluto and could actually be one of my supervisors..

My Tree View, which works, looks like this then…

Code: Select all

Employees Supervised by James Stephenson
> Mickey Mouse
   > Minnie Mouse
      > Goofy

Now when I expand Goofy it will look like this…

Code: Select all

Employees Supervised by James Stephenson
> Mickey Mouse
   > Minnie Mouse
      > Goofy
         > James Stephenson
         > Pluto

Here is the problem…

If I click on James, under Goofy, the system goes into an infinite loop.

The odds of a ‘lower level’ employee being the supervisor for someone higher up are pretty low, but it could happen.

My question is, is there a way to either not show me again when I am looking at this, or is there a way to not allow my record under Goofy to be expanded?