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.