Looking for "contains" operator rather than = when filtering a portal with a drop-down menu
I'm setting up a database to help organise songs played at church. I have a scheduling layout with a portal to songs for the user to refer to. The portal can be filtered according to the key the song is in and according to a "tags" value list (e.g. hymn, standard, new song). The tags field in the songs table is set using a checkbox setup and the filtering of the portal is done with a dropdown menu. The calculation for the portal filter looks like this:
(Schedule::Tags_Global = "All Tags" or
Schedule::Tags_Global = Songs::Tags) and
(Schedule::Key_GLobal = "All Keys" or
Schedule::Key_GLobal = Songs::Key)
It works well with a 'Refresh Global value' script triggered by both gobal fields.
I run into a problem, however, when a song has more than one tag - it doesn't show up in the filtered results. e.g. if a song is tagged as a 'hymn' and a 'new song', that song won't show if I filter the portal with 'hymn' or 'new song'. What I would like is an operator to replace "=" - something like 'contains' in the second line of the calculation. Can anyone suggest a solution? I am learning FM as I go.
Thanks in advance!