InfoPath Dev

I am attempting to populate several fields from the values returned from a secondary source connected to SQL Server. The first time I select from the drop down, the text boxes get filled correctly, but when I select another item from the drop down, the text boxes do not get updated. Any idea where I should look to figure out what is wrong?

Hi Dean,
Can you be more specific with the repro steps and send us the solution so that we can look at it?

This does seem a little weird, check out this HowTo:
http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85

I attempted to use the HowTo article, but I'm a little bit confused about the following step.
Select the option to Edit XPath (advanced), modify the XPath by appending an XSL conditional statement at the end to match the following example.

xdXDocument:GetDOM("Clients")/ClientInfo/Clients/Client/Name[../ID = current()]
When I use [../ID=current()], I get the following error:
"xdXDocument:GetDOM("JobMaster-Pworks")/dfs:myFields/dfs:dataFields/d:JobMaster/ID" does not point to a valid location path of a field or group.
Removing one of the periods before the /ID makes the error go away and I have the following statement:
xdXDocument:GetDOM("JobMaster-Pworks")/dfs:myFields/dfs:dataFields/d:JobMaster/@Job_Description[Job_number = current()]
But I do not get any data in the text box control.