AnsweredAssumed Answered

Filtering Text in a Portal with a Partial Match

Question asked by CodySteele on Feb 12, 2011
Latest reply on Feb 14, 2011 by Sorbsbuster

Title

Filtering Text in a Portal with a Partial Match

Post

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:

WORDS

EnglishWord

SpanishWord

PHRASES

EnglishPhrase

SpanishPhrase

Thanks for any help!

Outcomes