I am new to the Zoho creator app builder tool.  I have a simple design question.  I came from an Oracle development background.  In many Oracle typical screens, there is a List of Value widget like Dropdown that is based on a SQL query or dynamic query.  Typically, there is a code and a description value where you want to show the description on the drop down but physically store the code value.

How do I set this up in Zoho Lookup or Dropdown form widget to do this?  For an example, if I setup a Form named Country that has two fields, one for Country code e.g. US and one for Description e.g. United States.  When I define the State/Province Form, how can I setup a dropdown so that it shows United States, but physically store US into the Form?

Or do you just don't do this type of design and just show Description directly?  I know that the HTML dropdown can support code vs description type setup.  But how do you make Zoho to generate this.

Any idea will be greatly appreciated.  Thanks in advance.