I am making a small database program to run our club. The club members pay in one of 4 currencies when they visit our club and use our facilities. Because of the volatility of exchange rates, we set them manually and change them when needed.
I want to apply an exchange rate to a transaction...