I have a column to capture MEMNAME which is a REF from table USERS.
I have another virtual column (WALLET) to display a value based on the selection from table USERS.
I have the following formula in WALLET :
The issue I have, is when the value of MEMNAME changes, the value of WALLET does not.
Any guidance would be appreciated.