Multi-selection to filter a different table

[Harriswe]

Is there a way to use the ‘multi-select’ feature to select multiple ‘terms’ to use as a filter on a second table? I have a Glossary of terms’. I would like to select terms and then filter a Product table that has all the terms selected, not just any term (as happens when using an IN statement).

Glossary to Products is a many -to- many relationship.

I have an action that attempts to capture the glossary terms selected, by copying them to a Search table. Although this is generating an error.

Any ideas greatly appreciated.