How to Bind textbox/ListBox from one List with dep

Question

I have a DropDownList which is populated with One SharePointList in INFOPATH DESIGNER and the value for other textboxes are filled depending on this DropDownList Selected Value using Rules & Action. This works fine.

But, now i want to retrieve data in TextBox or ListBox which is present in Other List.(Want to use ClientID as LookUp value)depending on the Selected value of Dropdownlist.

Eg: ClientList(ClientID,Name,City)
    ClientAddress(ClientID,Address1,Address2)

Depending on ClientID from DropDownList the TextBox Value must be filled with Corresponding Address1,Address2.

Help Appreciated! Thanks!

Answer 1

Create a data connection to the other list, then create rules to fill the text field. There are several ways:

1. Set the ID field of the query fields in the new data connection to the value of the form field, then query the data connection, set the value of the target field to the data field of the new data connection

2. set the value of the target field to the value of the new data connection, filtered by the ID value of the form field.