2 Replies Latest reply on Jul 11, 2011 8:49 PM by cashdollar

    Searching multiple fields with a dialog box

      Title

      Searching multiple fields with a dialog box

      Post

      Still operating above my skill level with Filemaker.

      I've put together a database with a list of interpreters (contact info, languages, other employee info), list of Vendors (with contact and billing info), Appointment (which pulls together info from the other tables, as well as scheduling info), and a calendar to visually map it all out.

      Most of it's done, but right now I'm looking to search for all speakers of a particular language to schedule interpreting appointments. I'm thinking of creating a separate layout called "Language Search". It will be based on info in the"Interpreters"layout/table. In the Interpreters layout I have 10 pulldown fields under a tab labeled "Languages". The Languages field draw from a common "Value List" with all of our available languages. Many of our interpreters speak multiple languages, so they could have up to 10 languages that they speak. Because we offer more than 40 languages any particular language could be listed in anyone of the 10 fields.

      When we get a request for a particular language, I'd like to enter a layout and be prompted to type in a language name (or select it from a pull down menu) and have it return the name, phone, email of all of the interpreters that speak that language. That language could be in any of the 10 language fields for the particular employee. 

      I'm assuming I need a script to pull this off, and they're still kinda kicking my a**. I'm able to edit and tweak, but I can still only write basic scripts, without screwing thing up.

      I hope I've made my need clear. Any help would be greatly appreciated!

      Thanks.

        • 1. Re: Searching multiple fields with a dialog box
          philmodjunk

          And what do you do when you get an interpreter that speaks 11 or more languages? Think of the changes you'd have to make to support that change.

          Instead of 10 different fields for recording the languages each interpreter speaks, create a related "languages" table where you have one related record for each language spoken by a given interpreter. Not only will this make searching for an interpreter that speaks a specific language simple (you now have just one field to search for all languages), it will make many other reporting tasks easier to set up should you need to do so with your database.

          • 2. Re: Searching multiple fields with a dialog box

            That worked great. I inserted a portal linking to the languages table and it works great! Thanks.