How to create AND and OR search for fields that contains words separated with ','
I really need help for this filemaker script making issue. Basically, I m given a field that takes in texts and all the keywords in it are separated with commas.
Example : Keywords: New, Mathematics, Model
So when the user clicks on the "AND" button, it converts the keywords into New AND Mathematics AND Model and then perform a search based on it.
Any ideas? I would really appreciate it :)