InfoPath Dev

I have a dropdown in a infopath form. The items are comin from the DB via webservices. The dropdown is populated with a ID as a value and a NAME as the display name - no problem with that.  Now i want to set another field with the displayname of the selected value.  How can we achieve that?  If we use the xpathnavigator of the main data source / add rule to 'Set a field's value' with the selected value, it would set the ID (which is the value of the dropdown); not the display name.  Any help would be appreciated.

Hello & welcome!

I would set the other field to the Name field from your secondary data source and then filter based on the ID being equal to the field in you Main DOM connected to the dropdown that is populated from that secondary data source. Does that make sense? Let me know if you need more detail...

Can you please give me some more detail.  I am little confused. Thanks.

Hi,

Enter following formula as text box (Another field) default value. Double click on the text box and enter below formula in the default value field.

“Name[@id = field1]”

Name – Display name from Secondary xml.

ID – ID from Secondary Xml.

Field1 – Dropdown.

Thanks Anuma & Swathip.  That worked.  When the user don't see the item which they are looking for, i have to give them the ability to add new items which create records in the DB & open up this same form with the newly added items.  I am thinking to have a button to add new items next to the dropdown and in the managed code of the button call a new IP form which adds the records to the DB, closes and refreshes this main form.  Any help on how to do that?

Or is there any other better approach to do the same?