searching found set or refine search

[dmcwhirt]

Do you know of any way in FileMaker to have just the records in the found set, re-searched for a second criteria?

If you modify the find and add a second search criteria it seems to search the whole database again and this is a big performance issue for us in regards to the Web.

I know in some other databases I could command "just search the found set".

thanks

[BobWeaver]

Unfortunately, this is one feature that FM doesn't have.

My workaround (which is not necessarily faster) is to set a flag field in the current found set using the replace command. Then I include this field as part of the search criteria in the subset search. This won't necessarily speed up the search unless the user's original criteria was fairly complex, because the the flag field index has to be updated, and the subset search will still search the entire database anyway. But, it may simplify how you create the subset search.