Find related record
This may be silly but I´m breaking my head. (Winking FM 12)
I´m working with a contacts DB and on the list view I need a search box where you can write the name/last name you need, like:
Search field: S
Search field: Sim
Search field: Simp
Something like that. What I did is a new table named "Search" and with a field Searchlm related by = , wrote a script to simply contrain or Find Matching Records and constrain.
My list is based on the table Files and have 2 fields to relate: name and last name
Any help would be appreciated.
Thanks for reading
Check out the search portals in 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 get a copy of this file converted to the newer file format.