Hi Mike,

Using the "current()" function can be a bit confusing! :-)

Let me describe how my sample looks and then I'll include my original and
modified XPath expression.

1) I created a new, blank form
2) Added a data connection to the Products table from the Northwind sample
database
3) Added a Repeating Table, with just 2 columns, to my form
4) Changed the text box in the first column to a drop-down list and changed
the name to: fldProduct
5) Changed the name of the text box in the second column to: fldPrice
6) Set the properties of fldProduct so that the "Value" is ProductID and
Display Name is ProductName
7) Added a Rule to fldProduct to set the field value of fldPrice

So basically this is basically the scenario you describe. However, it
appears as though your initial XPath is not correct. What you want to occur
is: "set the value of fldPrice to the UnitPrice field from my secondary
data source where the ProductID field in my secondary data source is equal
to the ProductID from fldProduct on my form."

So, here is what you would need to initially do for the filter:

- Choose to Add a Rule
- Add Action (Set a field's value)
- Click the builder button for the "Field" option
- Select your Main data source and drill down to select the appropriate
field where you want the price to be displayed
- Click the builder button for the "Value" option
- Click Insert Field or Group
- Choose your Secondary Data Source and drill down to the Price data field
- Click Filter Data and then click Add
- In the first drop-down box, choose Select a Field or Group
- Select the ProductID field from your Secondary data source
- In the second drop-down box, leave this as "is equal to"
- In the third drop-down box, choose Select a Field or Group
- Select your Main Data Source and drill down so you can select the
drop-down box that displays your Products (for me, it is: fldProduct)
- Click OK until you get back to the Insert Formula window and click the
Edit XPath option

At this point, my XPath is as follows:

xdXDocument:GetDOM("Products")/dfs:myFields/dfs:dataFields/d:Products/@UnitP
rice[../@ProductID =
xdXDocument:get-DOM()/my:myFields/my:group1/my:group2/my:fldProduct]

What you need to do now is change this so the XPath is:

xdXDocument:GetDOM("Products")/dfs:myFields/dfs:dataFields/d:Products/@UnitP
rice[../@ProductID = current()/../my:fldProduct]

** NOTE: You interpret this as: "Give me the UnitPrice (@UnitPrice) Where
the ProductID (@ProductID) is equal to the product I selected from
fldProduct on the current row I am editing."

When I test this now and add rows to my Repeating Table each price is
correct for the item selected.

I hope this makes sense and I did not confuse you! :-)

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights