InfoPath Dev

I have a browser enabled form that has a drop down list linked to a sharepoint list of customers. The sharepoint customers list has fields for customer name, address and ID. This drop down list box allows of course one of the many fields to be used, I've selected the customer name. The issue I have is that on the same infopath form I want to display the address of the now selected customer name on the form and I just can't figure out how to do that. This would not only help to "auto populate" the form fields but it would solve an issue I have where I do have multiple customer records of the same name on this sharepoint list with different addresses. The issue being that people can't tell what the address is, all they would see in this one drop down list are two records example "Company abc, Complany abc". It would be super nice if as they select the first "Company abc" a field right next to it display's the address, they then could move to select the next company abc and see the address for that one ect.

 Can I do this with browser enabled forms, and if so how please. This would take my forms to a new level!  :)

You should be able to put a rule on the field which the drop down is bound to.

Use a set field action to set the address field based on the name, although if you have multiple identical names that might be an issue. You may need to use the ID or something. or make your names unique in your list.

I believe this should be browser compatible.

Hi,

You have two drop downs, one for customer and one for address of selected customers. For dislpaying the address of selected customer from first dropdown follow these steps

* create secondary data source for retrive data. (name it Customer) this will fetch customer info from SP list. while creating this secondary data source keep the checkbox ON for retriving the data on load.

* create another secondary data source for retriving data. (name it Address)  this will fetch customer address info from the SP list. while creating this data source keep the checkbox OFF for retriving the data on load

* copy the following code

public void Customer_Changed(object sender, XmlEventArgs e)

{

XPathNavigator cities = MainDataSource.CreateNavigator();

cities.SelectSingleNode("/my:myFields/my:Address", NamespaceManager).SetValue("");

SetAddressOptions();

}

private void SetAddressOptions()

{

FileQueryConnection q = (FileQueryConnection)this.DataConnections["Address"];

q.FileLocation = q.FileLocation + "&FilterField1=Custcode&FilterValue1=" + GetAddressValue();

q.Execute();

}

private string GetAddressValue()

{

XPathNavigator nav = this.CreateNavigator();

string filtervalue = nav.SelectSingleNode("/my:myFields/my:Customer", this.NamespaceManager).Value;

return filtervalue;

}

This is working fine for me for my web based infopath form running in SP environment.

Hope will work for you as well

Enjoyyyyyyy

Bhavesh