Get a field based on the current user

Hello,

I have a table called Team Members which is all of my users in the app.  The key field is the user field.  I use this to keep other fields related to each user and one of them is their Team Name (each individual in our company works on a Team/design studio)

We also have a few people that handle spillover if any team is too busy.  So they float between teams to assist with work.

I am trying to make a dashboard widget to show overdue tasks for a team lead so that they can see all overdue tasks on their team.  I am using Mark's method for the Current User is on a team = 1 flag, but that doesnt work in this case as I am trying to get the "task" if it is on a team.  Not a user.

So what I need in my report is basically the ability to say

If a task team name matches the current user team name show it on this report.

Ideas?

------------------------------
Ivan Weiss
------------------------------