https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/10669.aspxTue, 21 Nov 2006 09:06:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10669Patrick Halstead0https://www.infopathdev.com:443/forums/thread/10669.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10669Hi BurkedP and welcome!<br />I don't know the answer for you. We are not very knowledgeable of Access scenarios. It's possible InfoPath just doesn't support this. If you have a SQL database, we have a Web service that supports this scenario of writing rows to a detail table. Please send me e-mail if you'd like to try it out. Sorry I wasn't more helpful!https://www.infopathdev.com:443/forums/thread/5922.aspxThu, 16 Nov 2006 22:42:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5922burkedp0https://www.infopathdev.com:443/forums/thread/5922.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5922I have a form with master/detail relationship, saving to an access database. Now what I'd like to do is to add a record to another table whenever the form is submitted. This record would save basic information to build a revision history for the form, basically who and when.<br /><br />Database design key fields:<br /><br />MasterTable: RecordID<br />DetailTable: RecordID,DetailID<br />RevisionTable RecordID,RevisionID<br /><br />I don't need to recreate the details of the prior revisions, so I'm not keying the master or details to the revision. That also reduces my database size.<br /><br />When I create my databse connections, I'm only able to add a single detail table. If I add a secondary connection for my revision history, it is readonly.<br /><br />I am using Infopath 2003 sp1 with visual studio 2003.<br /><br />Anybody know how I can accomplish this?