I have a checkbox field in a table. The field has categories eg red, blue, big, small, heavy.... etc.
When multiple check boxes are selected in a SEARCH on a layout, records are returned which are the AND (intersection of the records). I need to find any record, which has the category field selected, that is the OR (Union) of records.
eg if big and heavy are checked I want all records with big and all records with heavy and all records with big and heavy.
I tried to write a script but see no way to implement it.