Hello,
I am trying to write a copy function for InfoPath Document connected to an ACCESS2007 DB.
The Document contains two main tables with 4 repeating tables connected.
In all there are approximately 80 collumns in this document.
If a user clicked on my custom "Copy Button", I would like to perform the below functionality.
1.) Save the XML data to a temp environment.
2.) Initialize the document with the same functionality as the "Add New" Button.
Clear all data and set the primary keys for the each of the tables in the document.
3.) Read the XML data and post back all the columns EXCEPT the key columns(we always end the column name with "ID")
I was able to read each column individually, but that can get tedious when have over 80 columns, not to mention a maintenance nightmare if the document gets new columns in the future.
Any help would be greatly appreciated.
Regards,
Tom z...