I have an InfoPath form which contains a list box which is populated from the unique names contained in the SME field of a SharePoint list. The populated list box now contains five entries:- Peter, Paul, Mary, Mary & Paul, Fred. You'll notice that one of the entries contains two names
I then use the selection from the list box to generate a Query connection to the SharePoint list, which will return those entries that match the selected name. All works well at this point except that when I select Mary, I see all of Mary's entries, and likewise with Paul
However, If I select Mary, I like to include the entries which contain Mary & Paul
Is this possible?