I have a form I'm creating in Infopath 2007 (non-browser) that pulls records from a sharepoint custom list. Each record in this repeating table requires some input from the user... which I need to store back into sharepoint.
To keep it simple, I won't mess with trying to update the list itself. Instead, I will store it in a document library (the end result will be an excel extract to do lookups on anyway so it doesnt matter where it is)
But when I try to publish my form and map controls to sharepoint columns (via a content type)... it doesnt let me map the fields in the repeating table. I suppose the logic makes sense, because it's an array within one record, so to speak... but I want it to create an entry in the doc library for each of the records in the repeating table.
Is that possible, or am I going down the wrong road here?