I have a list of currencies which I want to add to a different database to do calculations and can mathc the "GBP", "USD", etc fields but cant get the value to be adjust dynamically if they change in the currency table.
Has anyone come across this issue?
Basically I want to do a lookup in table A for "GBP" and in table B, where it its also labelled "GBP, and return the correspoding value in table B one column to the right X.XX.