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/59597.aspxMon, 04 Oct 2010 21:00:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:59597jenfi0https://www.infopathdev.com:443/forums/thread/59597.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=59597<p>nobody knows how to do this?</p>https://www.infopathdev.com:443/forums/thread/59553.aspxSat, 02 Oct 2010 23:28:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:59553jenfi0https://www.infopathdev.com:443/forums/thread/59553.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=59553<p>hi,</p> <p>i want to know how can i add new records to a sql database table that has a foreign key relationship with another table using infopath form.</p> <p>i have created a blank form based on database</p> <p>i have all my fields and the &quot;add new&quot; button already in the form.</p> <p>i have the username and the userid&nbsp; and some other fields filled in automatically when the user opens the form.</p> <p>i want that the user does not have to fill in his name, id and some other fields everytime he opens the form. </p> <p>only a part of the form like new vacation days must be filled in as new. so when&nbsp;the user&nbsp;click on the &quot;add new&quot; button i dont want that it clears all the fields. i want it to only set the new vacation days as new fields to fill in. </p> <p>when i fill in the form with new data and click submit. it gives me this error:</p> <p>Field or group: BE_CODE<br />Error: Only integers allowed</p> <p>this &quot;BE_CODE&quot; field has to be filled in the database table, it can not be null. but it must not be filled in by the user it self. and it is a repeating table so it can not be auto increment.</p> <p>&nbsp;</p> <p>is there an easy way to do this?</p>