The fields I am using for the filter already have index. And I am not talking about running the query. The problem is when we are creating the report. The screen to set the report (chosing fields, filter, sort order......) are very very slow.

>>Hi
>>
>>I have a free table who is having about 180 000 records and 200 fields. When I try to make a new report with the wizard the screen are very slow. For example when I want to set a filter I click the ADD button and set the filter. When I click OK after the filter is set it take about four minutes to be back to the previous screen. My computer is a 333 Mhz with 128 MB ram, the system is Windows NT4. If I try the same with a small table all the screen are very fast.
>>
>>Can you tell me if there is a way to speed up FoxFire.
>
>Create indexes on all fields you are using in your filter.