I am building a database that catalogs research expertise and currently have a dedicated field (Keywords) for large blocks of text that summarize one's area of research. On a separate layout, I have a text box holding a field (ResearchAreaSearchString) that I would like to use to search the field Keywords via a script.
From the user's perspective, they would be presented with a frontpage showing the ResearchAreaSearchString box. They would free type in the box and that text would search the fields Keywords via a script, automatically returning only those entries with a match.
Could someone describe the best practice for doing this in Filemaker?