It should be set index list based on the office selected.

>>
>>Unfortunately at this time all we really have budget for is a quick and dirty solution using filtered indexes and changing indexes on the fly.
>>
>
>What do you mean? You're going to create indexes on the fly? That's dirty and definitely not quick. SET KEY will knock your socks off!