Hello FM users, I've a question over currency.
I've Currency field from related table to store the currency rate.
Users will manually change for updated currency rate.
I’m going to have two fields for US price and China price
I believe creating calculation field on US price and China price fields will work to multiply and divide with currency rate field from related table.
If users choose to input in US price field for an item, it will automatically convert price for China Price field.
If Chinese currency (Yuan) goes up, it will be updating in China Price.
If users choose to input in China Price, it will automatically convert the price for US Price.
Even though Chinese currency (Yuan) goes up, it will not change because we purchase the item when currency is not up.
I will be really appreciate any of your advice or help.