https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/71455.aspxThu, 27 Oct 2011 15:03:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71455Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/71455.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71455<p>The issue is going to be with item 1 - InfoPath secondary data connections to SQL don&#39;t allow you to pass in a value from the form natively. This leaves you with some options:</p> <ol> <li> <div>Write your own code to do this - you&#39;ll need to alter the command of your secondary data connection - here&#39;s an <a href="http://msdn.microsoft.com/en-us/library/microsoft.office.infopath.adoqueryconnection.command.aspx">MSDN page</a> with a sample. </div></li> <li> <div>Write your own web service to do this - again, this involves writing your own code.</div></li> <li> <div>Purchase a web service - Qdabra&#39;s DBXL can do this kind of query - more info <a href="http://www.qdabra.com/en/products/DBXL.aspx">here</a>. (Free trial available)</div></li> <li> <div>Purchase qRules - it has a command for modifying a SQL query - more info <a href="http://www.qdabra.com/en/products/qRules_new.aspx">here</a>. (Free trial available)</div></li> <li> <div>Return all rows from database1 and use filters for populating your fields based on the ID your user selects. If database 1 is small, this may be an acceptable solution for you - <a href="http://office.microsoft.com/en-us/infopath-help/filter-the-data-that-is-displayed-in-a-control-HA010024281.aspx#BM1">this</a> is an article on add filters that may give you an idea of how to do this - you&#39;d need rules on the field where the user enters the ID to set your other 4 fields based on the data from database 1 having the same ID as that the user entered. If this is an option for you, I can put together a simple sample for you that may help as well.</div></li></ol> <p>Hope that helps!</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/71394.aspxTue, 25 Oct 2011 16:47:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71394w3stfa110https://www.infopathdev.com:443/forums/thread/71394.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71394<p>This is a desktop form (not web form) using Infopath 2010. </p> <p>1. I&#39;d like the user to enter an id number, click next, and then query the database1 for that id and populate 4 fields. </p> <p>2. Then just have the user verify the data and then have them click Submit data button to insert those 4 fields into a different database2.</p> <p>Right now, they separately look up the information in our custom app and then type it into 4 textbox fields and click submit to enter it into database2. We would like the above method so we can avoid data entry typos and errors.</p> Is this possible? I have connection for database2 able to submit. the secondary connection is read only but I&#39;m not able to connect the two in the process that I want. Any help would be greatly appreciated! <p>edit: or another option is have a textbox and then once they click a button, have the form run a query based on the ID entered to insert the data.</p>