The find is doing exactly what you are asking.
Renaming is the simplest solution.Finding recordsWhen you perform a Performing a quick find in Browse mode.in Browse mode, FileMaker Pro searches across all the fields that are enabled for quick find within the selected layout. Quick find is helpful if the data you are looking for might be in multiple fields or if you don’t know which field contains the data. For more information, seeWhen you perform a find in Find mode, FileMaker Pro searches through all the records in a Making a find request., comparing the you specify with the data in the table. For more information about performing a find, seeRecords with data matching the criteria become the, which is the subset of records being browsed. Records that don’t match are omitted. You can then constrain (narrow) or extend (broaden) the found set in Find mode.You can work with just the records in the found set. For example, you can view, edit, calculate summaries for, Opening multiple windows per file., print, delete, , or replace data in these records. You can also open another window in order to perform different find requests on the same data. For more information, seeYou can also perform a find in Browse mode based on an entire field or a selection of text within a field. For more information, see Finding records based on criteria in a single field.Topics in this section
I'm sure this is basic, but I'm still not sure I understand. When I try to find a record by clicking the find button and then selecting my 'available' radio button and hitting enter, I should only be getting the records in which the 'available' radio button has been clicked. Is that not correct?
I tried to change the name of my 'consign available' button as I suspected the word 'available' was triggering the additional found result, but that didn't change anything.
Though if the word 'available' was triggering the additional records to appear in my search, then wouldn't that be the same for when I click the 'consign available' button? When I perform a search for 'consign available' I am getting only those entries that have that button selected. That functions correctly.
Does that clarify my question?
The help links that davidanders posted explain what is happening.
If you search for 'John' in a name field it will find 'John Wayne', 'Wayne Johnston', 'and 'Trapper John'.
If you want to find the set that includes 'Wayne Johnston' you have to look for '=johnston'. If you want to find only the 'Wayne Johnston' record then you could search for "Wayne Johnston" (there are other ways too.)
When you search for 'available' it is returning every record where the word 'available' is.
I am not suggesting this is a neat solution, but it will work technically and shows the problem and source of solution:
- change all your existing values, and values list items, to be:
Now when you search for any of those terms you will find only the set you want, as no words are common. If you just search for 'consign' (by creating a duplicate of the field and having it as an edit box) you would find all records of the last two types.
One way to find "sold" but not "consign sold" would be:
Enter Find mode
Select new request from the requests menu
click consign sold
click the omit button at the top of the screen
perform your find
Thanks for both of those suggestions! Really helpful.
How about putting "==" in front of your search.
It searches for an exact match.
Try it out. Go into find mode. And enter ==sold in your field.
Then see if you only get the "sold" records.
DaSaint - as I understand it the problem is Samara only has a radio button to enter the search criterion. That would be nice in a script.