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/107001.aspxFri, 10 Jun 2016 23:01:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107001Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/107001.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=107001<p>&nbsp;Hi - we had a brief chat over email on this, but just to answer this question - if the form is a database bound form, you&#39;ll have to write code for this to change the connection for the Main data source prior to submit.</p>https://www.infopathdev.com:443/forums/thread/106898.aspxMon, 06 Jun 2016 02:16:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106898cab4110https://www.infopathdev.com:443/forums/thread/106898.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=106898I have a database connection with 2 tables. One I am querying to see if a record exist, then if the record does not exist I should add the data to table two. whenever I try to submit the data - I get an error massage which tells me it is trying to write to table one and not table two. How can I make sure it is writing to table two. the ID Field is required for Table one but the ID field is not required for table two. What can I do to make sure I am writing to table two and not table one. Thanks Carol