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/7791.aspxTue, 04 Oct 2005 05:54:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7791Patrick Halstead0https://www.infopathdev.com:443/forums/thread/7791.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7791Hi absMing,<br />I'm not sure I understand. If you write code, you can do whatever you want. In general, best practice is to map your form's main data source to one primary table. You can have multiple foreign key table updates too, but mapping a main data source to multiple tables is a non-standard practice and will cause you grief.<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/4952.aspxSun, 02 Oct 2005 22:34:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4952absMing0https://www.infopathdev.com:443/forums/thread/4952.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4952Gday,<br /><br />Is it possible to submit to a table [Y] in a database where table A-B (main connection) and Tables A-B doesnot have a relationship with table Y?<br /><br />Hope this make sense<br />Thanks for your help<br />