Hi
I have following structure for business unit and teams
Company (BU)
Unit1 (BU)
Department1 (BU)
Team11
User1
Team12
User2
Department2 (BU)
Team21
Team22
Unit2 (BU)
Department3 (BU)
Team31
User1
Team12
Department4 (BU)
Team41
Team42
I wanted to have a lookup that would return all the teams under the parent business unit of the teams to which he belongs
For user 1 that would be all teams (all teams of the parent business units of his teams)
For user 2 that would be Team11 and Team12 as he has onlu Unit1 as parent business units of the teams to which he belongs.
But I don't seem to find a way how to achieve this with a view.
Is this possible or do we need to find another solution?
Extra info : all users do have read permissions on all teams, but when assigning something not all teams should be allowed for every user.