Re: Duplicate data in Main Data Source from Secondary Data Source (Web Service)

Clay Fox — Sat, 24 May 2008 00:36:23 GMT

yes you need code to iterate through all of the repeating nodes.

I think Greg has some blog posts on this.

Duplicate data in Main Data Source from Secondary Data Source (Web Service)

Patrick — Thu, 22 May 2008 18:58:59 GMT

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!

Data Connections

Re: Duplicate data in Main Data Source from Secondary Data Source (Web Service)

Duplicate data in Main Data Source from Secondary Data Source (Web Service)