Let’s say that I have 2 tables. One table is populated by codes and references from the second table, and the other has an ID field, a lookup from first table (codes), and a third field with text quotes
Second field could include multiple selections, either a code or a list of codes.
I’ll paste an example at the end
If I want to filter using one value from the table using a formula, it works. For instance
bulletedlist(Lookup([Text quotes],Code,[code 1]).Quote)
However, if I try to filter using compound expressions, like
bulletedlist(Lookup([Text quotes],Code,OR([code 1],[code 2])).Quote)
The result is blank
Other way of expressing the problem: the second field of first table is populated by this formula:
It is not blank if code field on Text Quotes table is filled with just one code and not a multiple selection
My question is: how can I write a formula which returns results refered to multiple selections?
Thanks in advance!