Reference Main repeating table from database

[Tim Larson]

I have a databse connection that populates correctly. However I wish to copy
that list to a repeating table so that the .xml form contains that
information when it is saved. (I extract it from there for generating a word
document using a XSLT) Is this possible? Thanks

 

[S.Y.M. Wong-A-Ton]

Yes, this is possible. You can add the database connection as a secondary
data source to your form and create a repeating table in the Main data source
of your form. You can then retrieve the data from the secondary data source
and use XSLT to transform it so that the data "fits" into the XML structure
of the repeating table. I did something similar in this article:
http://enterprise-solutions.swits.net/infopath/transform-data-secondary-data-source-xslt.htm

A second option is to retrieve the DOM of the secondary data source and then
loop through all the nodes while filling the corresponding nodes in the
repeating table in the Main data source.