Well the super low tech way is simply to create a table of exchange rates with three records in it. The key field of the table will be the currency code and you would have entries for the conversion factor. The conversion factor for GPB would be 1.000, the US rate would be about 0.75 and the conversion for the EU would be about 0.89.
He would make a relationship between the currency exchange table and your transactions table to look up the exchange rate and then have a formula to calculate the Total Price multiplied by the exchange rate.
Everything would be converted to a common currency.
The other factor to consider is whether you were looking to make the conversion at the current exchange rates or do you want to freeze them at the time the records were created. If you want to freeze them at the time that the records were created then you can use what is called a
snapshot field. (see link for Help) This will be an additional numeric field Which will hold the frozen or snapshot it value of that exchange rate at the time the transaction record was created.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------