Hi. I have info path form with the repeating table. Repeating table is created from the secondary data from another list. The form also has approve button. My need is that once the form is approved, the data in the repeating table should be captured so when the form is opened (after approval ) the data in the repeating table does not show any data that are changed in the another list.
Is there a way to copy repeating table generated from the secondary data connection to another repeating table.
An example would be Info-path form which has a repeating table generated from the data pulled from the secondary SharePoint list called purchaseItems. After approval of that form, it should not display any modification or addition of data in the secondary list purchaseItems. So if someone adds an item or modifies the item in that list that should not be reflected in the approved Infopath form.
Thanks,