I have a quick question. I am trying to convert foreign currency to USD. I have a conversion table with four fields
Fiscal year (Current)
from currency
multiply rate
I need to able to identify which is foreign currency and convert it into Local currency. I have a field in my other table which indicates which currency it is.