Hi Andy, teams are really just used for creating exceptions to the standard security model via sharing. They are not designed to enable reports or queries to consolidate data.
In the standard CRM data model a user can be a member of zero or more teams (a one user to many teams relationship). So there is no such thing as a "user's team" unless you create a new attribute, relationship or entity for indicating which team a user
belongs too. An attribute is usually the easiest way to do it.
Regards, Neil
Neil Benson, CRM Addict at Customery Ltd.You can reach me on
LinkedIn or
Twitter, and you're welcome to sign up to
Customery, an online community for UK-based Dynamics CRM people.