If I search plastin or *plastin* it does not find the record. If I search mCherry, it does find it.
Isn't it exactly the other way around?
I don't understand your reply. Isn't what the other way around?
Let me add to my confusion. I am now trying out the newest version of Filemaker and how it searches. When I search fim I find 5 records in the database. When I search *fim* I get 9 records. But I can see no logic to why it found the extra 4 in the second search. Some have extra letters before and some after but so do some in the first find.
The default search is for words starting with… . Therefore, searching for plastin DOES find pEF6mCherry-T-plastin, but searching for mCherry DOES NOT - because it has no words that start with mCherry.
If you modify the search to *mCherry*, it will find any record that contains the string, including pEF6mCherry-T-plastin.
See the help for more on this:
but why would *plastin* not find it?
*plastin* DOES find it.
Which exact version are you using?
Filemaker 6 and it does not find the record. I am demoing Filemaker 10 at the moment and that does find it.
Don't you think that's worth mentioning?
The rules are different in version 6: for one, "pEF6mCherry-T-plastin" is a single word; for another, there is a rather short limit on the length of index values, so "pEF6mCherry-T-plastin" is indexed as "Pef6mcherry-t-plasti". You can still find it by forcing an unindexed search:
There is an oblique lesson here about the advantages of following the 'one fact per field' rule.