Jump to content

searching found set or refine search


dmcwhirt
 Share

This topic is 7516 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7516 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.