AnsweredAssumed Answered

Exchange rate

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

Title

Exchange rate

Post

Hi,

 

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.

Outcomes