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:
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)?
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):
row two would be:
row three would be:
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:
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".
Thanks, Beverly. I couldn't clearly see the posted image, so I answered the wrong question.
Thank you so much Beverly!
The thread on this forum might help, too:
Retrieving data ...