That thread seems a very good match to your problem. Field A in your post would be the "Currency_Type" field in my example.
Let's see if we can clear up the "how to part". What part of that post don't you understand?
Hi PhilModJunk, i don't understand nothing((( but something is missing. Can you rewrited it step by step?
1. I makes table named "CurrencyValues" containing 2 values: CurrType (text) and ConvFactor (Number)
2. This i dont understand at all: Put a matching field for CurrType in your main table and make this your drop down menu.
i makes new dropdown value list, and added currency types "dollar euros and lirs" named Currency.
3. i Makes a relationship between your main table and CurrencyValues:
2) I mistyped my last response. From your original post, you already have this field, the field you called "field C".
Field C is a drop-down associated with the selected currency.
So you shouldn't need to add a new field as you already have it.
the Define your relationship:
YourTable::FieldC = CurrencyValues::CurrType
Just make sure that the values in CurrType are exactly the same as those in your value list for FieldC
4) you need a number field where you enter the unconverted currency and a calculation field that uses the conversion value from the related table to compute the converted value. You enter the value in 1 field and see the converted value in the other.
Thank you Phil, can you please write it step by step? because for me this is still unclear.
And for everybody else, who'll search this question, will be more easy.
But the other link already spells this out step by step....