I 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.
Can anyone tell me how they handled a many to many issue please.
Cheers,