Add an index on the office field.
>The problem with using views is that the view based on the primary office would be terribly slow to requery, unless I'm not understanding what you're saying.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer