I'm working on a database where they often search using checkboxes. The value lists for the check boxes contain spaces and this is causing incorrect result sets to be returned.
Example list values would be
2. Newsletter Do Not Mail
If they click the Newsletter in find mode the results returned will include both Newsletter and Newsletter Do Not Mail. Is there a way to force it to find an exact match only. I know how to do this with "" or == but not using a checkbox.
The reason I couldn't use the "==" is there are other checkboxes for this field and people could be members of other groups besides the Newsletter ones. With the "==" I only got members who were in the Newsletter groups only. If they belonged to anything else it didn't match.
Thanks for the help. I've tested it and it works well.
Without the quotes I get results from both. The case that causes the most problems is
2003 China Meeting
Without quotes, if I select China Member I will get results from the other 2 also. If they had named them with an underscore instead of a space this wouldn't be a problem, but Filemaker matches on the China by itself and on Member by itself becuase of the space.
In that case you do need the quotes around the search string, since you want to find records containing the phrase "China Member", not just the words "China" and "Member". But records containing only the value "2003 China Meeting" would not be returned in either case.