March 7, 200817 yr 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.
March 7, 200817 yr When I search for Casey C it brings up both Casey B and Casey C record.... Why? Because C finds Casey.
March 7, 200817 yr I am afraid you misunderstood me. Casey finds Casey. C finds C AND Casey (and any other word that begins with C).
March 7, 200817 yr Author 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?
March 7, 200817 yr Author Here is the sample database. In the work order layout is where you will want to search. Summaries.fp7_2.zip
March 7, 200817 yr 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.
March 7, 200817 yr Author 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 :)
Create an account or sign in to comment