Find in filemaker 5

[Zeth]

Hello everybody,

I am new to Filemaker and sadly I have to use Filemaker 5 pro, which is outdated. I have a schools.fp5 database with "schoolid" as a text serial and "schoolname" as a text field. In main.fp5 I have a portal that shows all the schools from schools.fp5. Now I want to be able to sort/filter the portal results by typing into "searchfield" (text) and clicking a button which would execute the search function. I want to be able to search with incomplete school names, eg searching for "Jeff" would return "Jefferson Highschool". How do I go about doing it? Any code is appreciated. I found a somewhat similar example at http://fmpportals.blogspot.com/2007/11/example-simple-filter.html but as it is a newer filemaker file, I couldn't even open it.

[Tim W]

Hi Zeth,

Here is a sample file which might help. Ray Cologon's NightWing Enterprises site still has his demo files for fp5 available. Finding Similar Values (filtered portals)

Hope this helps,

Tim