InfoPath Dev

Hello,

I have a form with several repeating sections. The data collected in the repeating sections needs to be pushed to an SQL table. I have my query working if there is only one set of data in the repeating section. However, if I have more than one set of data (two or more repeating sections filled out), how do I access the information? Is is stored in an array? If so, how is the array refernced?

Thank you in advance for your help.

Bill

Hi Bill,
First off, I don't completely understand your scenario, so let me ask some questions:
1. How many repeating sections do you have?
2. Are the repeating sections nested?
3. Do the repeating sections map to separate tables in your database?
4. Do these tables in your database have dependencies? (foreign key relationships?)
5. Are you trying to access this information to submit the data to the database, or display the data in your form?
More soon,

1. There is an indefinte amount of repeating sections. We are gathering data on all the doctors a person has seen in the past 10 years.
2. No that are not nested.
3. Current they are form variables not fields mapped to a table.
4. I want to push the data to an array to use the information in another form which will be opened passing the array as a parameter.