-
This unfortunately is not possible with secondary database-type data connections. You cannot use a form value in the SQL statement. To be able to query secondary data connections the solution is a web service.
If you want one that is installable and ready to go try the Database Accelerator and look at the tutorials. It also includes ...
-
Hey Bruce.
I think you are making this more complicated then you need to. One of the great things about InfoPath forms is that you can do most things without code.
Open up the control (double click) which the user makes the selection from and then create a rule. You should set a fields value as the action, select your target field, and ...
-
I thought of a better idea.
Have a rule on your accountnumber field that they enter into which sets itself with the space padding.
Then have a rule afterwards which does the lookup for the account name.
Same result but simpler.
SO pad first then do the comparison, if adding the spaces manually always works then this should fix.
-
OK How would I do it....
I would move it to SQL
I would create an actual account numbering scheme
Along those lines I had a thought.
Why don't you use a drop down with the account name? You can enter a letter or number to jump to that part of the list. That may be easier?
Another Idea would be to use a list box or drop ...
-
Creating a page with the HTML redirection should be easy to find. It has been a while since I did one but it is just a simple line of text for the syntax. Then you should be able to save it with an aspx file extension. The only trick is whether IIS will interpret it correctly since aspx usually have a lot more to them. But a simple ...
-
Are you still working on this Ed or did you get this all working finally?
-
I would think you could use redirection within IIS. Set the button to a aspx page which just does a redirect to the form URL you want.
-
Thanks for the follow up on this DJay!
-
To verify the data you are getting from SharePoint, drag the data group from SharePoint on to your form as a repeating table and see what the data looks like when previewed or opened.
I would check your field format in InfoPath that the drop down is bound to. It should be a whole number or text type. You also can open up the properties of ...
-
If you have a database type form you can submt what you query back to the database. You may want to check out the Database Accelerator and web services if you want more flexbility with how you query and submit.
Qdabra Database Accelerator Suite Version 2.1 - Developer