Data Connectionshttps://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)Re: Read/Write front end to DB ???https://www.infopathdev.com:443/forums/thread/12267.aspxTue, 05 Sep 2006 17:16:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12267Greg Collins0https://www.infopathdev.com:443/forums/thread/12267.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12267Not the data connnection -- the submit.<br /><br />My mistake from earlier. It is many-to-one relationships that IP2003 doesn't like. It should be fine with one-to-many.Re: Read/Write front end to DB ???https://www.infopathdev.com:443/forums/thread/12266.aspxFri, 01 Sep 2006 20:13:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12266trufooser0https://www.infopathdev.com:443/forums/thread/12266.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12266what do you mean, one-to-many relationships kill the data connection? I have 40+ tables in my main connection and it works fine.Re: Read/Write front end to DB ???https://www.infopathdev.com:443/forums/thread/12265.aspxFri, 25 Aug 2006 17:39:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12265Greg Collins0https://www.infopathdev.com:443/forums/thread/12265.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12265You might try the IP2007 beta. I believe it has better data base support.<br /><br />But in general the one-to-many kills submit for DB in IP2003. A Web service would be required in this case.Read/Write front end to DB ???https://www.infopathdev.com:443/forums/thread/12121.aspxWed, 23 Aug 2006 18:09:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12121aviy0https://www.infopathdev.com:443/forums/thread/12121.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12121I want to use InfoPath as a Form to capture data, saving it to the database WITHOUT managed code. The database uses one-to-many realtionship tables. Once I have conneted to my Access DB, I am able to ADD TABLES using the wizard, associating them much like they are associated in ACCESS, but as soon as InfoPath suspects a one-to-many realtionship - it disables SUMBIT. <br /><br />Can InfoPath do what I want? Or is this more complex and requires code.