Hi,
I have been working with this problem for a couple days now. My Main Data Source has a lot more fields than displayed below, but here are examples of my Data Sources (using a 1 column sample of the data):
Main Data Source
OMS
QuoteManagement_sec (repeating group)
QMS_VendorName_txt (text box)
Secondary Data Source (Web Service)
myFields
queryFields (group)
dataFields (group)
VendorCircuitQuote (repeating group)
VendorName (text box)
I can receive data back from my web service just fine. It populates non-repeating data and repeating data into my form appropriately, and there is a unique identifier in each row of the returned data.
I need a way to take the values that get returned to a repeating table from the web service and duplicate those values to a repeating table that I created in my Main Data Source.
We'll call these tables WebTable and MainTable, respectively.
I tried to test this with a single field. I have inserted the repeating table from my Main into the form and set the default value of the field (QMS_VendorName_txt) to equal the field (VendorName).
The problem arises after I refresh the query. The values populate the WebTable, but only one row is created in the MainTable, with the value of the first row equal to that in the WebTable.
I suppose I need a way for the MainTable to check how many rows are created in the WebTable and populate each row with the corresponding values.
I can provide pictures, more description, i.e. whatever else anyone needs to understand further. Can anyone help?
Thanks!