I see that this question has come up before but I cannot get this to work.
I am trying to retrieve data from a table in Forms and, using Workflow, insert each row from the table into separate rows in an MS Access database table.
The Retrieve Forms Content activity of the Workflow is pulling the table fields in to workflow as multi-value fields. So I am using the For Each Row activity first and then Insert Data to try and get it to parse through each entry of the multi-value fields.
But Workflow is still just taking the data from the first row of the table (i.e. the first values of each of the multi-value fields) and inserting them over and over again in the table. So I get 10 rows in my database table of the first row of the original form table.
i don't know how to parse out each multi-value field so that it goes into separate rows in my MS Access table.