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.
Take a look at the search portals at the bottom of this demo file: https://www.dropbox.com/s/0pm1gdqcfi2ndpv/EnhancedValueSelection.fp7
If you are using FileMaker 12 or newer, use Open from FileMaker's File menu to open the file and produce a copy in the .fmp12 file format.