Dear Filemaker users,
I have a table with lists in the field name LIST. I want to be able to do a search through these lists and show only the row that has a match with a certain value in the field name list.
F.e. the following lists occur in the field name LIST:
list 1: 1 11 13 78 9
list 2: 32 91 2 1 14
list 3: 2 31 11 92 101
I want only the records to be shown that have the value "1" in the field name LIST. Which would result in showing only the records that include list 1 & 2. In Excel I would use the MATCH function and then use a filter to show only the rows that show where the value "1" has been found.
I hope you guys/girls can help me.
Btw: I own a Filemaker Pro product, so custom functions are unfortunately a no-go.