Hi,
I have a secondary data source that I get from a web service. I based my Main data source off of an xml schema that I created.
I have a secondary data source with a repeating table with multiple columns, one with a text box with an ID, and other columns (one of which is a name).
I have a main data source with a repeating table with 2 columns; one has an ID number in a drop down which is populated from the secondary data source. The other column has a blank text box. I would like the user to select an ID from the drop down and based on that, have the text box populate with the corresponding name from the secondary data source repeating table.
Main Data Source Repeating Table
I used this formula in a rule (set within the drop down) to "Set a Field's Value" (the text box's value). This is the formula: (i am not too experienced with XPath)
VendorName[VendorCircuitQuoteId = current()]
I don't know if that's enough info, but any help would be great. thanks