Hello,
Really hoping someone might be able to point me in the right direction:
I have a requirement where I have an infopath form attached to a SharePoint 2010 list library (NOT a form library). There are four sections on this form that allow multiple entries. I have currently implemented repeating tables that save the data to 4 external SharePoint lists. I also load and filter based on a related field when the form loads.
My major issue is that I cannot for the love of me find any way to allow the user to edit those details and save them back to the list. I know I have a related field but most solutions I try, I hit roadblocks.
I was thinking as a last ditch attempt I would:
- On Submit save each item to SQL in a custom table.
- Have a windows service or timer job save those items to SharePoint on a regular basis
- Pull these up again from the SP list when the user edits the form.
- Execute some custom code on submit that works out based on the ID which record in the SQL table needs updating.
This solution seems over complicated and slightly ridiculous to me though as I feel like that has to be a more simple solution.
Would anyone have happened to have tried this before? Am I missing a big piece of the puzzle? or is this the most elegant way of dealing with this in InfoPath?