3 Replies Latest reply on Jun 6, 2011 8:57 PM by aammondd

    Drop down Box Display

    PeterDowns

      Title

      Drop down Box Display

      Post

      Hi 

      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

      Cheers

      Peter