Find searches the word index. When you enter Tom T, it will find Tom, and all words beginning with T, so that is why you are getting three records.
Try =Tom T
It appears you are not using quotes in your search as stated in your post. Tom T will find 3 records "Tom T" with quotes will find 1 record.
Yes of course thanks for the reminder, I thought something odd was going on, client pressure and all that. I know about the "==" but don't normally use quotes, so thanks for that and the swift replies
FileMaker default search is "begins-with" on any word in the field. Add to that, the AND find you have (words separated by space). Then you know why you got your results.
Aside: the order of the AND search don't matter.
would have also given you
There are several 'wildcards' that can assist with the searches.
== is exact, for example &
Quoting puts your space into the phrase so ignores the AND search for two values. It searches (still begins-with) for the phrase.
May also find
Sent from miPhone