1 Reply Latest reply on Mar 3, 2014 8:49 PM by philmodjunk

    Need a better "SEARCH" for records

    Mike_1

      Title

      Need a better "SEARCH" for records

      Post

            

           I am having issues when trying to search for records within a field called ACCOUNTS. I want to begin to type and have filemaker search a the field containing any variation of what I am typing. My problem now is it looks for only beginning characters and does not catch duplicate names.

            

           example... 

           In search field I type the word FIRE looking for accounts with the word Fire.

           Results I get in a dropdown list....

           FIRE STATION #1

           FIRE STATION #2

           FIRE DEPT

            

           It will leave out accounts like...

           THE FIRE STATION

           MAINSTREET FIRE

           or Duplicates of anything such as if I have FIRE DEPT twice it will leave one out of my search list. Also if there are 2 instances of the same account name I need a way to tell the two apart by displaying the addresses of each. 

           Thanks

           Mike