When you enter find mode and specify find criteria, FileMaker uses partial text matching to find records. That's the standard result unless you specify otherwise.
as your criteria and the scripted find will no longer find CSC records. Your script can take the text from the pop up menu and put "==", the exact match operator in front of that value as the find criteria.
For examples of scripted finds, you may want to examine this thread: Scripted Find ExamplesCaulkins Consulting, Home of Adventures In FileMaking
That's a great option, but a problem arises when I have a single button to perform a search, but would like partial text matching for some fields but not all. For instance, I would like to save my users time if they are looking for records with a word that might have different endings, like say "insurance" and "insure", so just type "insur" and that all comes back. If I have any term they use put in with =="term" that won't work anymore, right?
Is there a way this can be set up to only function on certain fields via my search script?
I don't see the issue. You should be able to set up your script to use the == operator with some values and some fields and not with others.
I will look more closely at the scripted find examples and see if I can figure out how to have it only work with some fields and not others. I just cannot determine the syntax right now.
The examples use Set Field to specify find criteria. The "calculated result" parameter of set field is just that--a calculation and so you can set up a calculation that uses the exact match operator with some values of the pop up menu field and not others.
And if your script is specifying criteria in more than one field, you'll be using a different set field with each field and thus you can again pick and choose which set field steps include the exact match operator.