I have a user record database which has
employee, userinfo1, userinfo2, managername
foo1, info1, info2, foo2
foo2, info1, info2, foo3
foo3, info1, info2, foo4
as now I have
manager level foo4 -> foo3 -> foo2 -> foo1
foo1 has three manger on top of him
how do I setup data model so every employee has manager and his manager and his manger all the way to top.
that way when I search for foo4 I get every employee under him and not just direct report employee.
is this possible?