Are you doing this with a script or are you entering find mode, clicking a check box and then performing the find?
If you are using the script, please post the script you are using:
- You can upload a screen shot of the script by clicking the edit link to your original message and uploading it there
- You can upload a screen shot of the script to a file share site and post the download link to a new response you post here.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF.
- If You have FileMaker advanced, you can generate a database design report and copy the script as text from there.
No script, I just entered the values in the value list manually. I then created a text field named "Standards" and set it as a checkbox field using the value list as the data.
On the form it shows great in the checkboxes
I click one of the checkboxes with a value of say 6" (ADA Standard) and all is good and records display correctly.
I go into find mode and select the box click Preform Find, and get the error message "No matching records"
Upon further testing values like 6", 7', work great in finds values that have text after the 6" like 6" (ADA Standards) give the error message.
I'm assuming the " or the ≤ ≥ characters are what is causing the problem. I thought there was a way to enter a for lack of a better term "literal modifier character" that caused the next character or symbol to just be treated as text not as a mathmatical symbol of FIND operater.
Yes, Filemaker is interpreting the inequality characters as operators. If you were to enclose that text in quotes it would not be so interpreted. You could for example enter "≤7" (quotes included) into a copy of this field formatted as an edit box and it would find your records.