Mapping Infopath fields to Sharepoint columns

Question

Any one has any idea how to map an infopath field to a sharepoint column of type choice? The infopath field is a repeating field, so the user can select multiple options, I want to be able to map those to the choice field in sharepoint. Any ideas?

update: What I'm trying to do is the following. I have a choice column in sharepoint which allows user entered values. In infopath, I have a repeating field. I'm binding the field to a dropdownlist. The dropdownlist gets filled by a webservice. This dropdownlist is in a repeating section, so the user can choose to select from multiple dropdownlists. So lets say the user adds 2 dropdownlists, and selects an option from each dropdownlist. I want to be able to add those selections as choices in the sharepoint choice column.

Answer 1

SharePoint list is a flat structure, and because of that Infopath does not allow you map repeating sections to list columns.

You might wanna consider the following workaround:

• Store Infopath form to one library (along with non-repeating fields)
• Use one of these custom activities to extract data from repeating table and copy it to another list
• Create a custom data view or a web part to display these items (if necessary)

This approach can be useful if you need to do some additional tasks with the repeating data.

Answer 2

When you are promoting fields within a repeated section into SharePoint columns, the options available are to promote the column as:

• first (i.e. only the first selection is promoted)
• last
• count
• merge (I believe this merges all the selected values together into a single entry)

screenshot http://img4.imageshack.us/img4/5539/repeatinggrouptr3.png