InfoPath Dev

Hello all, I have a a dropdown list control bound to the main data source in a SQL server. I would like to make the wild card query to the table by Supplier Name say Abc* and then pick only one record from the result set. In addition, the other fields in the form will be updated based on the record selected...

Hello, I'm trying to modify a form we have. The form searches the DBXL, and returns the search results in a list view. Well anyway, I'm trying to change it to search a different part of the DBXL, but I don't understand how it all interacts. I've made a basic working model that is pretty...