InfoPath Dev

Oh thank you so much!!!!! I spent whole day yesterday searching for the solution to my problem... This works like a charm!!!

Hilary you are the best.. Thank you. I have attached the template.

Thank you for the quick reply. Here is the full XPath. xdXDocument:GetDOM("spVendors")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Rate[../d:Title = ../d:Title]

I have a form that I am working on. It gets information for a SharePoint list. My list has two columns. One called vendor on called rate. The drop down in my form to select vendor is working well but the rate that is returned regardless of the vendor selected is always the first rate from the SP list. The rule I am using to get the rate ...