Hi Craig!

Based on the numbers quoted elsewhere in the thread, he's concerned that extracting all records for a single office (150,000+ records) would be slow even with an index on office.

>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.
>>