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

    Need a better "SEARCH" for records



      Need a better "SEARCH" for records



           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.



           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...



           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.