Realistically an application has to take a snapshot. If you have continuous change of the exchange rate you never get a stable price and that would be bad <g>...
Imagine somebody sticking an item into their shopping cart and the price changing before the order is complete because of the rate change.
Typically you'd have to grab the rate at the beginning of a session and then at stick with it and use that same exchange rate for future calculations on orders. SO it'd have to be stored with the order data itself in some form.
+++ Rick ---
>>Yes, exactly, this is why I concluded last night that for the current application it was necessary to register with a professional Web Service to obtain that. I received some links in the other message that I will have to see if one of them can do the job.
>
>The nice thing about an overnight exchange rate as opposed to a "live" rate is the bookkeepping is easier.
>
>Imagine a customer calling with a claim that FOREX reported a different rate than the conversion rate used when the transaction occurred. You'd be sawing pennies in half!