I am trying to make portal filtering work with a search. I have used a global value for searching on numerous filemaker applications when the Find operation happens on the parent layout, very easy.
Now I am trying to show a found set in a portal and it is not working.
I can make the portal show a found set of EXACT matches by using $$Search = Tablename::firstname as the filter calculation. The problem is I want to be able to search using only the first couple letters., for example, type in "Mic" and have it show Michael, Michelle, Mckey, etc.
Currently it will show NOTHING unless I type in an exact match of the firstname. Running Filemaker Pro 12.
I also tried using the PatternCount function but the problem is that it lists all data with that text pattern anywhere in the name, example, if I type "mi" it will show all names that start with mi as well as Tami, Sammi, etc.
I feeel like this should be very straight forward and I am just mising something, but please help!!