I have a table named "Currencies" with CurCode and CurrDescription fields and a table named "Exchange" with From ( it takes the value of CurrCode), To (takes the value of CurrCode,in my case this is always set to EURO) and Rate Fields.
In a form with record source the table "Sales" I have a combobox with CurrDescprition, and a field called amount. The user enter the value in the amount field and he choose from the combo box the currency.
What i want to to is to get automatically the amount in EUROS based on the exchange rate and save it into a field called AmountInEuro, when the user choose a currency from the combo box.
Any suggestions?
Thank you in advance.
In a form with record source the table "Sales" I have a combobox with CurrDescprition, and a field called amount. The user enter the value in the amount field and he choose from the combo box the currency.
What i want to to is to get automatically the amount in EUROS based on the exchange rate and save it into a field called AmountInEuro, when the user choose a currency from the combo box.
Any suggestions?
Thank you in advance.
