I know the title only creates more questions... let me elaborate. We are building a supply request form that is used in Kuwait. Because of this, the unit cost may be in U.S. Dollars (USD) or it may be in Kuwaiti dinar (KD). Lets suppose the exchange rate is 3.290 KD to 1.00 USD; if I enter 329.00 USD in the "Estimated Unit Cost-USD" field, I want 100.000 KD (yes, the KD is rendered in 3 decimal places) to show up in the "Estimated Unit Cost-KD" field. Alternatively though, if we receive an estimate in KD and I enter 100.000 KD into the "Estimated Unit Cost-KD" field, $329.00 should show up in the "Estimated Unit Cost-USD" field.
So, I want neither field to be a calculated value so that we can enter values manually in either.
Finally, I want the "Total Estimated Cost..." fields to calculate the respected unit cost values times the requested quantity value.
Thanks and Regards,