6 Replies Latest reply on Oct 29, 2014 10:24 AM by beverly

    Search look up field

    lous

      Hi,

       

      I am very new to Filkemaker.

       

      Just wondering if it is possible to create a search look up filed (I know how to create a look up field, but it only searches records by first word)? Something like this:

       

       

       

       

      Thank you.pastedImage.gif

        • 1. Re: Search look up field
          Mike_Mitchell

          FileMaker automatically searches for any word in the field when it searches. Have you tried the Quick Search field (upper right-hand corner of the Status Bar)?

           

          toolbar.png

          • 2. Re: Search look up field
            beverly

            Mike is correct, in that FileMaker does a default "begins-with" for every word in a field. It looks like, tho, that lous is trying to get a value list to display based on the "search".

             

            There is the method of creating calcs (auto-enter would make it more indexable) and then making a relationship. FileMaker allows what is called a 'multi-line' key for a relationship.

             

            So if you have this in a field (several rows):

             

                 1. John Smith

                 2. Smith, Betty

                 3. George Smithe

             

            Your calc would separate into "words":

             

                 row one would be (return delimited list):

                           John

                           Smith

                 row two would be:

                           Smith

                           Betty

                 row three would be:

                           George

                           Smithe

             

            So a "Smith" match would get you records 1 & 2. If you need further "loose searches" then you further divide out the words into series of letters:

             

                 row one could have:

                           John

                           J

                           Jo

                           Joh

                           Smith

                           S

                           Sm

                           Smi

                           Smit

             

                 etc, that even the 3rd record could be found with "partial match" of "Smith". But you can see it can get quite complex!

             

            Many of us forgo the selection list (drop-down) and do a portal or selection list in another window (or perhaps pop-up object). Another window allows the use of the Quick Search that Mike suggests.

             

            I recommend that you search for "multi-line key" in your favorite search engine and see if there are articles on it. Remember that this is a FileMaker "feature".

             

            HTH,

            Beverly

            • 3. Re: Search look up field
              Mike_Mitchell

              Thanks, Beverly. I couldn't clearly see the posted image, so I answered the wrong question.

              • 4. Re: Search look up field
                lous

                Thank you so much Beverly!

                • 5. Re: Search look up field
                  lous

                  Thanks Mike

                  • 6. Re: Search look up field
                    beverly

                    The thread on this forum might help, too:

                     

                         <https://fmdev.filemaker.com/message/162190#162190>

                     

                    Beverly