Exchange Rates

[m10muhammad]

Hi

I am a relative newcomer to FileMaker so I would greatly appreciate any advice with regard to my problem.

Basically, I have a layout which includes details for machines in my inventory, such as make, model, age, etc. One such detail is Purchase Price. I deal with customers across the world so the Purchase Price may be in USD, CAD, EUR, GBP, or JPY (I have a Purchase Price Currency field from which I can select the appropriate currency from a value list.)

I also have a Purchase Price in USD field, which converts the Purchase Price to USD, depending on the Purchase Price Currency I select (the field references fields where I input the exchange rate manually each day).

What I hope to accomplish is to set up an automatic exchange rate so that my exchange rate fields can draw from live data and calculate Purchase Price in USD accordingly.

Please advise how this can be made possible.

Thanks.