AnsweredAssumed Answered

Exchange rate

Question asked by chris_ on Sep 3, 2009
Latest reply on Sep 3, 2009 by chris_


Exchange rate




I'm new to creating databases and I need some help.


I'm trying to create an exchange rate database. Basically it will convert U.S. dollars to Canadian. It will be an invoice where I will put the daily exchange rate in a field and have it convert the U.S. amount.


So basically I set up a database where I put the exchange rate in a container and I have one field when I input the U.S. dollar amount and I have another field next to it that's a calculation that multiplies the container by the U.S. amount and gives me a total.


The problem I have is that when I change the exchange rate, all the previous records change. How can I make it so that the previous records don't change when I change the number in the container.


I hope I explained it well. Thanks in advance for any help that can be provided.