https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123056.aspxWed, 27 May 2020 16:40:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123056Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123056.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123056Excellent - glad you are all squared away. It took me a while to really understand current() in XPath, but it really is the answer to a lot of these "filtering in a repeating group" questions. Have a great day!https://www.infopathdev.com:443/forums/thread/123055.aspxWed, 27 May 2020 16:33:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123055MGLITTL0https://www.infopathdev.com:443/forums/thread/123055.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123055Oh thank you so much!!!!! I spent whole day yesterday searching for the solution to my problem... This works like a charm!!!https://www.infopathdev.com:443/forums/thread/123054.aspxWed, 27 May 2020 16:24:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123054Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123054.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123054So - when I changed the filter to select the Vendor field in the main DS, InfoPath used the absolute path to the vendor - which would not have helped the situation at all. :) Instead, I manually changed it to use the current() function. Since the rule is on the Vendor node, which is in a repeating group, current() will always return whatever instance of the Vendor you just set the value on. Give this copy a try - right click the link in the heading of this post and save the file locally. Right click the saved file and select "design" - then you can preview and test it out.https://www.infopathdev.com:443/forums/thread/123053.aspxWed, 27 May 2020 16:11:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123053MGLITTL0https://www.infopathdev.com:443/forums/thread/123053.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123053Hilary you are the best.. Thank you. I have attached the template.https://www.infopathdev.com:443/forums/thread/123052.aspxWed, 27 May 2020 16:05:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123052Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123052.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123052Ok, so this looks like you are comparing the title in the secondary data source to the same field. Change the filter so that Title in spVendors = Title in your main data source....Feel free to attach a copy of your template under the Options tab in a reply if you'd like a hand. :)https://www.infopathdev.com:443/forums/thread/123050.aspxWed, 27 May 2020 16:02:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123050MGLITTL0https://www.infopathdev.com:443/forums/thread/123050.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123050Thank 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]https://www.infopathdev.com:443/forums/thread/123048.aspxWed, 27 May 2020 15:53:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123048Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123048.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123048The formula probably needs to use the "current" function.... in the formula editor, can you tick the edit XPath box and then paste in the full XPath in a reply?https://www.infopathdev.com:443/forums/thread/123047.aspxWed, 27 May 2020 15:39:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123047MGLITTL0https://www.infopathdev.com:443/forums/thread/123047.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123047I 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 is:Rate[Title = Title] (title is my vendor in SP). Any help on this would be great!!!