I have a database with several currency fields, purchase value, market value etc.... all set at "$" currency. Is there any way the currency value of a field can be changed to "£" based on a a script or value of a field?
I have thought about a seperate global field that contains the currency symbol, and changing the value field to a simple 2 decimal number. Then on exit from the value field, the currency symbol is placed infront of the 2 decimal number within the value field...?
Is this possible? If so, any idea of the script to achieve this...?