Drop down Box Display
another quick question
is it possible with a drop down box to select and display a description but store the related id field.
For example I have an chartofAccounts drop down box where the user picks an account by name and it stores the account code.
However it then displays the account code in the field that most humans wouldn't have a clue what it stands for. I need to keep the account code for storage because the name can change but not the code but I need to display the name so we have a slight clue as to where the money is coming from.
I know how to join fields and display 2 together for example but is that the only solution?
Thanks in advance