Infopath 2010 Wildcard Search
Posted on 2010-08-20
I am trying to develop an InfoPath 2010 form for Purchase requisitons and have a requirement that I'm having some trouble with...
We would like to do a wildcard search on Vendor name and number. I have a vendor list in SQL and created a concatenated column that contains both fields (for easier searching).
What I would like to happen is have a text box in the form that the user would enter the partial text string into (say %mel%, or 429%) and a button, that when pressed, would open a new window with the results (like the people picker does) or even a new view (probably easier). They would then pick the correct Vendor name/number combination from the list and it would populate the fields in the main form. The fileds in the SQL table are standard vendor stuff (Name, phone, fax, email). I'm looking for a way, primarily, to display the result set...VB is the code type for the template, as this almost certainly looks like a programatic solution will be required. I saw a code snippet in a post on here for a similar issue with InfoPath 2003, but it appears the script editor is not availble in 2010, and that post does not explain how the result set gets displayed and used (that I could see/undertand...)