InfoPath Dev

 Hello all,

I am really new to infopath. I have sharepoint list that have same column Firstname and Lastname and age.I have infopath form that contain two dropdown controls for firstname and lastname and one textbox for age. Now i want to write function that can take argument as selected values from both the dropdown and get value of corresponding age from sharepoint list and fill age into textbox.

Any help would be appreciated.

Thank in advance.

Can you use code in your form? If so let me know, i'll help you out with the code. If not, i'm afraid i do not know how.

Hi, you can certainly do that with codes but if you don't want to use codes I think it's possible

I suppose you have a list with first name, last name, full name and age columns. You can create a secondary data connection with this list and populate your dropdowns. You add a field and you put as default value: concat(My:last name; " "; My:first name).After that you add a default value to your age field with your secondary data connection and use a filter (your newfield = fullname of your data connection)

 Hello,  Thanks for reply. yes i use code in my infopath form. So please let me know how can i do this?

I am stuck here and can't find any suggestion. Thank you. 

First, you need to set an onChange event on your 2 dropdown boxes. To do so, right click your dropdown boxes --> programming --> change event. This will create a visual studio project with an empty function for your dropdown box. In this function, write this code (or something similar) :

XPathNavigator root = MainDataSource.CreateNavigator();
string FirstName = root.SelectSingleNode("<XPath of your FirstName dropdown box>", NamespaceManager).Value;
string LastName = root.SelectSingleNode("<XPath of your LastName drop down box>", NamespaceManager).Value;

 Thanks a lot for your help. It works fine. Again Thank you..