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
It will leave out accounts like...
THE FIRE STATION
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.