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...