I have created two lists say Country(Title,Id),Country Currencies(Title,CountryId,CountryName,CUrrencyCode).Id column in Country is related to CountryID in countryCUrrency.
Now in Infopath I have imported these lists.I have created total 4 dropdown lists.Country Name(Title from COuntry),Id(Id from COuntry),Currency Code(currency COde),COuntry Name(title) from CurrencyCOuntries.
My requirement is If i select a particular country name or ID in first two dropdowns,corresponding currency and currency code must be displayed in remaining two dropdowns.I hope my question is clear.
Now how can i achieve this.Can some body help me?