Here's what I have. A list with various forms of cancer and deadly illnesses. I used a multi select field where the data entry person could select multiple types of cancers or illnesses that the person had.
Now, they've come to me needing something else. They need to create a view for everyone who has breast cancer, another view for everyone who has any type of cancer other than breast cancer, and a third view for all the names that have some illness other than cancer.
So, if a person had Breast Cancer, Colon Cancer, and Cardiac problems, then they would only appear on the Breast Cancer View. If they had Colon Cancer and Cardiac problems, then they'd only appear on the Other Cancers view. If they only had Cardiac problems, then they'd only show up on the Other Illnesses view. Does that make sense?
Problem is, when I try to create the second view using the view Criteria as DOES NOT CONTAIN "Breast Cancer" I still see Breast Cancer results in my view along with the other cancer results. Is this because I used the multi select field?
I tried to do an IS EQUAL TO criteria and list the types of cancers on each line, but each of those results would be a "MATCH ANY" and not a "MATCH ALL" and still lists the Breast Cancer results.
I'm pretty familiar with Creator, and while not an expert by any means, I feel I know enough where I'm not sure why this is confusing me. I'm thinking I made the mistake in the beginning by using the multi select field to contain this data. I can do most things in Creator except I have shied away from creating my own scripting. I usually just use all the clickable buttons :-) but I'm thinking I'll need to create a script to make this work??
Thanks in advance for any help you can provide.