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/5501.aspxMon, 03 Apr 2006 23:54:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5501Carlos0https://www.infopathdev.com:443/forums/thread/5501.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5501I like to know if anyone has created an infopath form with an SQL many to many relationship. I cannot seem to get the results im after. For example, I have join table called branch_emp and two tables Employye and Branch in SQL. An employee can work one or more branches and many employees work in a Branch. I got the SQL schema OK, but when I use this in infopath it doesnt quite work. What it does is, as soon as I add a repeating section for employee, it automatically adds a repeating section for Branch, and vise versa. I dont want this because ill have 50 employees with 5 branches, but the way Infopath works is it gives me 50 repeating sections for both employee and Branch.<br /><br />Can anyone tell me how they handled a many to many issue please.<br /><br />Cheers,