Hi @Suvrutt_Gurjar , I using the expression in the User table. in the user table have the officers accounts, then I referenced it with clients table, from the clients table will be referenced to the KPI performance of that officer’s Client
I just changed the “Email” collumn from the manager table to “Manager Email” and the expression working now . the manager can see all the officers now.But it is not what I want . My company structure is something like this
officer A handle clients 1 ,2
officer B handle clients 3,4
officer C handle clients 5,6
officer D handle clients 7,8
- When officer A logging will see clients 1 and 2, the same with B, C , D
Manager E manage officer A,B
Manager F manage officer C,D
when Manager E logging will see the account of Officer A and B the same with Manager F
and there have another role
High manage team name G, H
when me and G,H logging will see the account of A,B,C,D
So what can I do to get there ? I have to make another table for high management team ?
What can I do to make this “Manager E logging will see the account of Officer A and B” happen ?
thanks for your support