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/3656.aspxWed, 13 Dec 2006 01:06:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3656Soham Bhatt0https://www.infopathdev.com:443/forums/thread/3656.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3656Found the answer - The reason its not allowing the Submit option is one or more of the tables in the data source do not have a primary key, unique constraint or unique indexhttps://www.infopathdev.com:443/forums/thread/1729.aspxWed, 13 Dec 2006 00:27:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1729Soham Bhatt0https://www.infopathdev.com:443/forums/thread/1729.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1729I have created a new form from Data connection option and dragged acorss the query and data fields - all good at this stage.<br /><br />i now want a submit button at the bottom that will allow user to submit the values back to the database. But i dont get an option to submit it back to the database.<br /><br />I create a button and in the properties i change the Action to Submit - Then i enable Submit commands and buttons. This is where i dont get an option in the drop down to the Database. <br /><br />Even in my Data connection - the Main connection have a description of only retrieving data from datatbase instead of retrive and submit.<br /><br />What am i doing wrong here?