"find in progress - Processing field "field_a"

[wootten]

field_a is a field in a related record on a layout.

when i want to find on that field the find process is way to slow. it takes minutes to perform.

the message i get is

"find in progress - Processing field "field_a"

is there something i am missing??

[CobaltSky]

The most probable cause is that field_a in your related db is unstored (and therefore not indexed, so a temp_index has to be created every time you do a find). If so, see if it is possible to set it to stored and indexed (or if it is itself a calc referencing a related field, try bringing the related value it is based on into your related db as a lookup and then setting field_a to stored and indexed).