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.