S
slowuptake
I have employee expense database. Due large amounts foreign travel, want to
add foreign currency capacity into the expense input form - and record into
the underlaying table both the original amount and currency and the amount in
base currency.
Foreign currency amount entered by way of text box - no problems.
Combo box allows user to choose which foreign currency from a list - no
problems.
List box looks up current exchange rate based on combo box choice - no
problems.
A separate text box calculates and displays the amount in my base currency -
no problems.
Problem - I can't figure out how to get calculated amount to be
automatically written into underlaying database. As temporary solution I now
manually retype the result from last text box.
I suspect the problem isn't that hard, but as usual, I'm ... slowuptake
add foreign currency capacity into the expense input form - and record into
the underlaying table both the original amount and currency and the amount in
base currency.
Foreign currency amount entered by way of text box - no problems.
Combo box allows user to choose which foreign currency from a list - no
problems.
List box looks up current exchange rate based on combo box choice - no
problems.
A separate text box calculates and displays the amount in my base currency -
no problems.
Problem - I can't figure out how to get calculated amount to be
automatically written into underlaying database. As temporary solution I now
manually retype the result from last text box.
I suspect the problem isn't that hard, but as usual, I'm ... slowuptake