https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/48446.aspxFri, 30 Oct 2009 23:26:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:48446Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/48446.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=48446<p>Hi--</p> <p>This can be done. You just need to first create a primary key on your table, then set that primary key to be a composite, by using more than one column. At that point, submit will be enabled in InfoPath. </p> <p>I first tested by creating a composite key without setting a primary key first, and had the same issue of submit being disabled. When I removed that key, set one field as the PK, then edited the PK to use an additional column, I had a composite primary, and InfoPath was fine with that.</p>https://www.infopathdev.com:443/forums/thread/48263.aspxTue, 27 Oct 2009 09:37:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:48263KidCarson0https://www.infopathdev.com:443/forums/thread/48263.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=48263<p>I am trying to insert data into sql table using Infopath 2007. Can I use composite keys in database? As soon as I create composite key and refresh connection in Infopath, submit is disabled. Does anyone have some expirince about this problem. </p><p>&nbsp;</p><p>Thank you.</p><p><img alt="" /> </p><p>&nbsp;<img alt="" /></p><img alt="" />