I have fmp 14 advanced and am currently trying to create a database with about 700 FCC licences (see brows mode interface screenshot below).
The problem is I am trying to create a easy interface so that I and future people using this database can find licences without having to search every location field with the exact same location. I created a "find" layout that I was going to use as my search interface (see image below) but my problem has become how do I create a script that will get the information I am searching for the "find" interface and search it in multiple fields in the brows interface.
The two most recent script I have been trying to use are:
Thank you in advance for any help you can give!