With respect to a Currency Field it appears that the currency symbol is more or less hard-coded within a record, but I was wondering if it is at all possible to make the currency symbol dependent on another field?
For example, I have a background table called Contract Prices which displays as a related table in the Contract records. We deal in multiple currencies, so my wish would be when I select the currency of the contract (Choice field) , I would like my price fields to display the proper currency symbol.
This is correct:
But this is not:
I thought about just making another Price field with a visible dependency, but then I run into the issue of having two Price columns in my related table view.