September 23, 2013
While you can create a SharePoint List Form to manage multiple SharePoint list items, it becomes a bit more challenging if you want to do the same using a normal SharePoint Form Library Form.
For the latter, you can write code and make use of the Lists web service to maintain multiple items in a SharePoint list. Such code does not require Full Trust to run, so InfoPath form templates can be normally published to SharePoint Form Libraries as sandboxed solutions.
Recipe 95 of InfoPath 2010 Cookbook 3 and InfoPath 2010 Cookbook 4 gives you the basics of adding items from a repeating table to a SharePoint list, and the Discussion section expands on how to add update and delete functionality to such a solution.
However, you can go a step further and expand the solution in such a way that users can easily add rows to the repeating table, update data in rows of the repeating table, or delete rows from the repeating table, and then when the form is submitted back to SharePoint, all of those inserts, updates, and deletes are written in bulk – so with only one call to the web service – back to the SharePoint list.
The InfoPath 2013 demo video below shows you how such a solution would work.