InfoPath Dev

I have a form that creates total mileage using a repeating table. The Miles control is populated from a SharePoint library when a company is chosen on the Infopath form. The first company works fine, but when I go to add another company, Miles duplicates the first company no matter what the company is. Here's the code for the Miles control:

xdXDocument:GetDOM("Company Mileage")/dfs:myFields/dfs:dataFields/dfs:Company_Mileage/@Mileage[(../@Company_Name = xdXDocument:get-DOM()/my:Technician_Mileage/my:Mileage/my:Client_Name) and (xdXDocument:get-DOM()/my:Technician_Mileage/my:Mileage/my:Override_Mileage != string(true()))]

Thanks in advance,

You will need to use the current function for this. Check out this HowTo I recently wrote and I think it should be able to get you on the right track:

http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85

Matt,
The drop down list works fine, it's the Miles control that is duplicating miles for the second company. I can send you the form if you'd like.
Thanks,

You will have to change your XPath to include use of the current() function. I'm not sure how your schema is laid out, but this might work:

xdXDocument:GetDOM("Company Mileage")/dfs:myFields/dfs:dataFields/dfs:Company_Mileage/@Mileage[(../@Company_Name = current()/my:Mileage/my:Client_Name) and (current()/my:Mileage/my:Override_Mileage != string(true()))]

Are you using rules on the drop-down or a default value formula to populate the miles field? Here are some references for the current() function:

http://www.google.com/search?q=xsl+current+function

We are using rules to populate the miles field. What is a Node-test expected error?