Populating a field from a database query

[Paul Webster]

I want users to be able to enter a currency into an Infopath form from a
drop down list, I then want a database to be queried to look up the
exchange rate for that currency and a field on the Infopath form to be
populated with the exchange rate to later be saved in the XML document.
It sounds straight forward, however I cannot work out how to do it. Can
anyone help?

Paul Webster

 

[Paul Webster]

I want users to be able to enter a currency into an Infopath form from a
drop down list, I then want a database to be queried to look up the
exchange rate for that currency and a field on the Infopath form to be
populated with the exchange rate to later be saved in the XML document.
It sounds straight forward, however I cannot work out how to do it. Can
anyone help?

Paul Webster

Well I have almost got there by attaching a list box to the exchange
rate in the secondary data source and then filtering where currency
(main data source) = currency (secondary data source) and saying blanks
not allowed.

It isn't however, very elegant, the user has to scroll down and select
the exchange rate from the list.

Would it be better to populate a control programatically, and if so,
how do I do it (using C#).

Paul Webster