AnsweredAssumed Answered

Need a better "SEARCH" for records

Question asked by Mike_1 on Mar 3, 2014
Latest reply on Mar 3, 2014 by philmodjunk

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

      

Outcomes