I have a list of 2000 text strings. Each string has several tags attached to it marked ON or OFF. Let's say SWEET, SOUR, SPICY, TART and SALTY.
I want the user to be able to make these tags either ON, OFF, or EXCLUDE.
So if the user selects SWEET and TART as ON, it will create a pool of text strings which have either of these tags. But if the user selects SWEET as ON and TART as EXCLUDE, it will create a list of all the text strings with the SWEET tag, but then it will exclude from this list any of these which also have the TART tag.
So far I can only create a pool of all the ON tags, and I can't figure out how to cull the ones marked EXCLUDE.
Is there a logical way to do this without assigning an ID to each text string?
I hope this isn't so vague as to be a waste of time asking...