Unindexed search speed up

[fmp7_user_fmp7fmp7]

Is there any way to make a search on unindexed field so that the search does not take an hour? I have a database of 40k records and I have to search a calc field(unindexed). I have tried to do a set field of the calc field with a regular number field but the setting of the field takes about as long as doing the find. Does anyone know how to help? Thanks

[Reed]

If it's not possible to index the calc field, and it's because it's referencing related data, could you set the field up as a lookup or an auto-enter calc that is stored. Then you'd be able to index it and speed up the search. You just have to make sure that the field stays up to date by controlling how it's updated.

If you could post the file (just save a copy as... clone (no records)) I could see how the calc. field is set up.

Dana