https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/53421.aspxWed, 07 Apr 2010 14:31:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53421Patrick Halstead0https://www.infopathdev.com:443/forums/thread/53421.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=53421<p>Ah yes, well that&#39;s a limitation of InfoPath and why we don&#39;t recommend using the out-of-box DB integration. We do recommend using Web Services and we have developed an insanely cheap and cost-effective Web service called DBXL to meet all of your needs. Free trial available at Qdabra.com. Find out more here: <a href="http://www.qdabra.com/en/products/DBXL.aspx">http://www.qdabra.com/en/products/DBXL.aspx</a></p>https://www.infopathdev.com:443/forums/thread/53392.aspxTue, 06 Apr 2010 19:59:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53392cguruc0https://www.infopathdev.com:443/forums/thread/53392.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=53392<div class="ForumPostContentText"> <p>hi, i&#39;ve been experiencing an issue with submitting when the backend is SQL. </p> <p>I have 2 tables&nbsp;CUSTOMER and REQUESTS table. Both tables has &quot;ID&quot; as a primary/unique key. And i have joined both these tables by &quot;customerid&quot;. When i use access as a back end DB, i have no problem submitting with the same primary key and relationship. However, I now require to change the DB to SQL and it&nbsp;does not allow me to submit anymore. I checked the Data connection wizard and right at the end, it says &quot;Submit option: Disabled.&nbsp;&nbsp;A many to one relationship might exist in the data source.&quot;</p> <p>What am i missing??? please help!!!</p></div>