I thought you were setting this up
I guess I might need an additional dataobject in the middle
It's the same site all the time. I am just trying to add new features that people want.
At the moment each team leader can see their team members which works very well. But now the regional managers think it would really help if they could see the people in the teams that they look after so I'm trying to expand things
But maybe I can create a region dataobject that has-one region manager & has-many teams
So, could you just add a relation from the regional managers to the people they manage?
As you just said 🙂
It might be worth using a many-many though.... for when you have a managers that want to view multiple teams
I literally just thought oh crap what about the London teams where there are multiple region managers working with all of them cos there are just so many teams in London!!! 🤣
I'll give it a go adding the in between data object & come back here if (when!!) I get stuck! Thanks for talking it through & helping clarify the approach 😀