https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/32916.aspxWed, 08 Oct 2008 04:15:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:32916Clay Fox0https://www.infopathdev.com:443/forums/thread/32916.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=32916<p>Default data base connectivity works that way, along with other limitations.</p> <p>You need SQL and web services to escape these issues.</p>https://www.infopathdev.com:443/forums/thread/32899.aspxTue, 07 Oct 2008 17:20:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:32899mzakharo0https://www.infopathdev.com:443/forums/thread/32899.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=32899<p>Hi - I would like to manipulate data from an access database, however, the data is split across multiple tables. Since main data connection in infopath (with read+write) access can only contain one file, I am stuck because I have to add multiple tables along with their relationship to each other. And if I add an entry to the &quot;main&quot; table, all related tables get updated with a new entry. Apparently, infopath thinks that all entries that are related have a unique binding to each other, however this is not the case, I just simply have multiple tables, each with different purpose. Maybe there is a workarround, however I could not find a way to just add multiple tables without relating them to one another. Please help. Thank you in advance<br /></p>