Hello all. I'm developing, or trying to, an InfoPath 2010 form that is in a SharePoint list. I'm not a professional developer so please excuse my ignorance to anything below.
I have two fields of concern with a specific task that I'm trying to accomplish, Lead and Short Title. The lead field is a listing of instructor names that are cleared to teach a certain course which comes from the short title field. The lead field contains multiple short titles in it so I can't do an equals to filter. I have it all worked out with one exception. I have a short title called CIM and that will also bring up lead names that are cleared to teach any course that has the letters C, I, and M in it. For this example, it also brings up MCI. Is there a way to make the contains filter look for the exact short title and not other variations of it?
Thanks for any help you all can provide.
Bob