I have text field with ControlSource bind to table field. I would like to see the diffrent value in the field but still to save the original one.
Ex:
Total: US$300 (should show on the form) and should save CAN$477

What is the best way of doing this?

Thanks in advance