Auto Search when Typing to narrow portal results

[no1tmorrow]

I am wanting to create a search box that as the user types in a field the results change in the portal. The catch is I would like it to work on an existing layout so the user doesn't have to switch to a find layout. I tried searching the forum but can't seem to find the answer, which I am sure is here somewhere.

 

Thanks

Thom

[mr_vodka]

Try a google search for filemaker type ahead portal filter or filemaker dynamic portal filtering and you should come across a bunch of examples

[bcooney]

Several techniques come to mind.

 

Actually, it's not really a "find" you need so much as a dynamic filter. Perhaps this blog from Full City will help: http://fullcityconsulting.com/portal-filtering-with-filemaker-11

 

Another approach is to use ExecuteSQL and grab the IDs for the records that match your criteria to use on the parent side of the portal relationship.