InfoPath Dev

It worked, thank you so much for your help Hilary, and you as well Jimmy. Thanks to you to my form is up and running perfectly, and I am now the only person in my office out of the 500 employees that knows how to use InfoPath. You two have helped me add another skill to my resume (I'm still a beginner, but I'm on the right track) and ...

well, in all my infinite glory, i found what the problem was. When i began trying to figure out the solution on my own before i started posting here, i had a rule setup in the account field, once i removed that rule, the code you taught me worked absolutely perfect! I want to thank you agian for all your help and putting up with a newbie like ...

It is set to query when the form is opened, i reloaded it to doublecheck and i should have noted that i changed the name of the XML doc to "System" from "Systems by sys prin" to make it easier for me to test my code   correct me if im wrong, but if it displays the State when i enter in the account number manualy,  ...

If im looking for the sibling of a note, wouldnt the syntax look more like this:    xdXDocument:GetDOM("Systems By SysPrin")/Root/Row[SysPrin = substring(xdXDocument:get-DOM()/my:CoachingOp/my:SetArea/my:account, 1, 8)]/following-sibling::Systems//Root/Row/State

The Error im getting now is:Function 'GetDOM' did not return a value, or it returned a value that cannot be converted to an XSL data type.   I get this error if I delete everything exept GetDOM("Systems By SysPrin") from the function box as well.  This leads me to believe there is something wrong with my XML ...

    But that would have made sense? why would i have done that? Sorry, skipped the morning coffie earlier

    im pretty sure you are right about that

xdXDocument:GetDOM("Systems by SysPrin")/Root/Row[SysPrin = substring("8XXXXXXXXXXXXX", 1, 8)]/State   This line of code works. however, i cannot get it to take the data from the account field.     Path i used to point the the account text box: /my:CoachingOp/my:SetArea/my:account     Is there ...

I want to start off by thanking you for your assistance Jimmy. However, the code is generating an error.   Your Code SuggestionxdXDocument:GetDOM("Secondary data source name")/Row[SysPrin = substring(xdXDocument-get-DOM()/path to account name in main data source, 1, 5)]/State  Code Suggestion w/ data ...

What I need to figure out is how to do this: When a user enters an account number, I need another control box to return the State(as in the United States) that is associated with the first 5 numbers of that account number (the System or "SysPrin"). I have an XML file (pictured below) that lists the SysPrin with the corresponding ...