>I have the following situtation. I have a table of approximately 121,660 records which have a region field. It is populated with either WDC (Washington,D.C.) or SFB (San Francisco). The records from DC total 71,448 and 50,204. The remaining records are for Chicago approximately 5. On the screen I have a optiongroup that will set a filter for the different area. All seems to work well for WDC and SFB but I am having problems with Chicago. The code set the filter, does a locate and then refreshes the grid. On the Chicago selection when I try to refresh the grid it just takes forever. Is this because it has to navigate thru the table or what. Any suggestions.
Milt, do you have an index on your region field?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison