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/16978.aspxTue, 09 Aug 2005 17:43:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16978Patrick Halstead0https://www.infopathdev.com:443/forums/thread/16978.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16978Hi Marc and welcome to our forum!<br /><br />Your first question is a deep architectural question. :)<br /><br />Usually, InfoPath works well with one primary table mapping to the Main data source. Secondary tables can be mapped to secondary data sources. Mapping the main data source to multiple database tables causes problems because of the pivots. Sometimes you want to pivot on one table. Sometimes on another. You can certainly put both tables in the Main data source (repeating groups under the main root node), but you will experience challenges because of the relationship between the two tables. If one table is always the "primary key" then you should just map the Main data source to that and have the other one referenced from it. That will simplify your life. You can always create another InfoPath form for the other table. <br /><br />I hope this helps.<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/16727.aspxTue, 09 Aug 2005 14:28:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16727nemegeerm0https://www.infopathdev.com:443/forums/thread/16727.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16727Hi,<br /><br />Can somebody explain me how to create a many to many infopath form ? I have created a form for both two tables, but I'm not sure how to design the form for the table that links the two tables.<br /><br />Thanks for your advice<br />Marc<br />