Hi, I hope this isn't a duplicate question.
I have an InfoPath form containing a number of repeating tables. The first table was created from scratch. The rest of the tables are almost identical, and they were created by referencing data fields from the first table. The repeating data elements are promoted as Merged. Data entry works correctly in all the tables. When I look at a filled-in form in an XML editor, each row of each repeating table has its own unique section and all data is present. For example, if a repeating table contains 12 rows of data, the XML file has 12 corresponding entities. All well and good.
However, when I look at the data in the SharePoint Form Library, I only see the first 11 rows from the first table. Although the rest of the rows & tables appear correctly in the form XML, SharePoint apparently doesn't load them from the XML. The column is defined as Multiple Lines of Text. Settings for the column are grayed out so I can't changes the number of lines displayed. Wouldn't help anyway since the data isn't there.
My question is: how can I get SharePoint to recognize and load all the rows from all the repeating tables in my form and display them all in the appropriate column?
If that's not possible, is there another solution that will allow me to access all the repeating table data from SharePoint?
Thanks.
SB