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 at the previous step. How can I do this? I am new to the Infopath. Thanks in advance.
If you already in SQL Server why not write a stored procedure to manage your query. Then you can return partial matches, and return values for all the other fields you want populated. If this is not an option You may need 2 fields to make this work, one for the search (wild card) and one for the results. the results will filter results based on your value in the search, but instead of equals you will use contains. Then apply rules to populate other form fields
I have a similar question, one of my drop down field look up from a sharepoint custom list column, i have 500 values in that column, so i want to enter search in the dropdown field, how can i do that? thanks in advance.
Thanks for your advice. I have created the stored procedure. Then how can I populate the dropdown list with the returned dataset?
funny you should ask. I struggled with this at first but was able to figure it out using this post.
http://www.bizsupportonline.net/infopath2007/programmatically-fill-populate-drop-down-list-box-infopath-2007.htm
This is a good writter for InfoPath solutions. Start with this and if you still cant get it I will post my updated code from the post that my help you.
yes. I have read this link before. Now the problem becoms how I can invoke the stored procedure and save the returned result into an xml file. Then the rest part is set. By the way, I am wondering if there is a simpler way to set up a parameteriized query directly for the dropdown list control.Thanks in advance for you advice! --- William