Populate a field from a Secondary Data Connection from a query valueof a dropdown list

[rob.j.arroyo]

In Infopath 2003 SP1

I have a dropdown list that auto populates from a secondary data
connection. The dropdown list is populated with the values of ID from
a repeating group in the secondary data connection. The secondary
data connection is the xml file below...

<myLocations>
<loc id="1">
<Address1>My Place</Address1>
<Address2>AAA Main St</Address2>
<CityStZip>Town, NJ, 00000</CityStZip>
</loc>
<loc id="2">
<Address1>Bob's Place</Address1>
<Address2>BBB Park Pl</Address2>
<CityStZip>City, NY, 11111</CityStZip>
</loc>
<loc id="3">
<Address1>Fred's Place</Address1>
<Address2>CCC Broadway</Address2>
<CityStZip>Grove, PA 01010</CityStZip>
</loc>
</myLocations>

When previewing the form I would like the select ID "2" from the
dropdown list and populate a field named "Address" with the
corresponding Address1 data, "Bob's Place".

Can someone please demonstrate how to do this?

 

[Ben Walters]

Hey Rob,
This is not difficult to setup however before I provide a solution I need to
know, are you using a web based form or will the template be opened using
the InfoPath client?

Cheers
Ben Walters

 

[rob.j.arroyo]

The form will be Full Trust, and not be a web form. People will use
Infopath client.

 

[Swathi (GGK Tech)]

Hi,
Follow the steps in the below link.
http://www.infopathdev.com/blogs/ma...e-Fields-from-a-Drop_2D00_Down-Selection.aspx