I've created an InfoPath 2010 form that has three Repeating sections and each one uses a different data connection but all three connections use the same table in SQL Server...
"Accounts". Now you might ask why I would do this? Well I need different sets of data in each section and it all resides in the same table in the repository. Also, sometimes one section will not have information and I do not want
a bunch of blank fields displaying in the repeating section. So I split the data into separate sections.
Now here is the challenge for you guru's out there. :)
I want to use one column in the 3rd repeating section
to refer back to another column in the first repeating section.(for referential integrity) Unfortunately since they both use the same table in the database they possess the same name under advanced view:
myFields/dataFields "d_:Accounts". In fact all three of my repeating sections have the same name based upon the database table used in the data connection.
In the SQL statement I attempted to rename each of the connections via the statement. I have not tried to give the table an alias in the statement yet. Will try that one next.
1. Is there a simple way to rename the repeating Section from "d_:Accounts" to something else so that
they are each unique? (Without using backend code as I've only used InfoPath/SP/S
View Complete Post