Find is funky

[UpNorth]

I have a field with a drop down list of names:

Casey B

Casey C

John D

When I search for records that contain Casey B, it only brings up his records. When I search for Casey C it brings up both Casey B and Casey C record.... Why? The only way I can pull up just Casey C is by putting " " around it.

[comment]

When I search for Casey C it brings up both Casey B and Casey C record.... Why?

Because C finds Casey.

[UpNorth]

hmmm... I also have Mishele C and it only brings up Mishele C??

[comment]

I am afraid you misunderstood me. Casey finds Casey. C finds C AND Casey (and any other word that begins with C).

[UpNorth]

Understood, if I type C into the find field it will bring up all records containing C. What I'm running into is I type |Casey C|(Fist name last initial) it brings up all records that have the word Casey in it, but when I type |Casey B| it just brings up records that contain "Casey B"

Does that make sense? I can attach a sample database if that would help?

[UpNorth]

Here is the sample database. In the work order layout is where you will want to search.

Summaries.fp7_2.zip

[comment]

It makes sense, and I'm afraid that's how it works. If you had an entry of just 'Casey', it too would be found by searching for 'Casey C'. Because the single word 'Casey' satisfies both criteria.

Keep in mind that when searching a text field, Filemaker actually searches the word index of the field, not the field itself (unless you modify the find, as you did by wrapping the criteria in quotes). There are no duplicates in the word index, so if you had an entry of 'Casey Casey' it would be indexed the same way as an entry of just 'Casey'. Now, searching for 'Casey Casey' would find them both, because each individual word searched for is found in the index of both.

[UpNorth]

Interesting, Thank you very much for your time and input on this. I thought it was something I was doing wrong, but I guess not :)