I don't have a verbal picture of all your relationships, but I think we are at the point where the Teams are identified that
[User Allowed Access] is 1 if the current user is in that Team.
You can look that up down to Team Member assignments to have a field called
Team Member Assignment is on a Team with the Current User.
Then flow that up as a summary field up to the Team Members to have a field called.
Team Member is on a Team with the Current User.
Then look that up with the same Name from Team Members down to Tasks
then filter a task report where
Team Member is on a Team with the Current User =1
What I suggest that you do is to look at your relationship diagram (you know that is a crazy useful built in tool, right) and tidy it up, if you have not done that already so that you can visualize your relationships. Then using this technique you can snake you way up and down through relations, with summary Max in those "1" fields going up and simple lookups on the lookups doing down.
by the way a compact way to explain relationships is like. Ie One Team has Many TM Assignments
Team < TM Assignments > Team Members < Tasks
Project < Tasks > Team Members (Assuming a task is just assigned to a single Team Member )
It saves a whole lot of typing if you can explain your relationships that way.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
