Filtering Text in a Portal with a Partial Match
I've got two tables which I have related ALL records to one another. I need a filter now to display those records from one table which partially match the text from a field in the other table.
I have one table with words. I have another table with phrases. In the layout view of the words table, I want to see those records from the phrases table in a portal which are filtered by the criteria that they contain the word currently being displayed. Unlike in a find where I would simply type *"myword", I can't use that in the syntax of a filter. What function can I use to accomplish this? My table structures are:
Thanks for any help!