Data Connections

Re: Populating Fields from Drop down

dlgross — Mon, 12 Jun 2006 17:34:46 GMT

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.

Re: Populating Fields from Drop down

Matt Faus — Sun, 11 Jun 2006 03:41:38 GMT

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

Re: Populating Fields from Drop down

Patrick Halstead — Sat, 10 Jun 2006 08:32:14 GMT

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

Populating Fields from Drop down

dlgross — Tue, 06 Jun 2006 19:17:40 GMT

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?