https://www.infopathdev.com:443/forums/141.aspxQdabra is committed to answering InfoPath questions. However, we do not support Microsoft Access. For non-Access questions, please use the other boards.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/38433.aspxSat, 14 Feb 2009 06:40:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38433Ian Dawson0https://www.infopathdev.com:443/forums/thread/38433.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=141&PostID=38433<p>In InfoPath, I am trying to work out why I cannot Submit to a database.</p> <p>Well thanks to Hilary&#39;s suggestions, I have added keys to all of the tables. Unfortunately, one table which has a primary key to relate to most of the client tables. I cannot see how to set up another key ( a secondary key) to a single supplier table. Try as I might, Access thinks a one to many relationship exists.</p> <p>And when I redo the data connection, The final Summary advises it feels there is a one to many rel. And disables the database submit.</p> <p>So I am thinking DO I HAVE TO WRITE SPECIAL CODE in InfoPath to allow a submit?</p> <p>Any clues?&nbsp; How to etc etc.</p> <p>Thanks</p>