List box with values to search through data field, wildcard match or wild match
Not sure if this is possible but thought I would ask.
Lets say, my data has a field called audience which contains values like "Director/Manager", "Manager/Analyst" and "Director/Manager/Analyst". Now, I know if i create a list box to filter the data, that it would have those same values. However, is it possible to just have in a list box the values of "Director", "Manager" and "Analyst"? Then it would go against that audience field and filter the data with matches the selection, almost like a wild card match or wild match.
So, if I select "Director" it would find the matches of Director in the records with "Director/Manager" or "Director/Manager/Analyst" and display both sets of results?