Customize the display values in a drop down list

We have a table of Worker Types: Code     Description WR        Worker SU         Supervisor MG        Manager We would like to create a drop down list with values displayed like this: WR – Worker SU – Supervisor MG – Manager Then, users can select a value and the appropriate worker type code will be saved to the Database, WR, SU, or MG. Is there an easy way to do this?
1 answers


I can think of a couple of ways:

  • Add another column to your table that has the two values combined the way you want them.  Populate this either as a calculated attribute (recalcs every time a row is retrieved) or using an event handler (recalcs when a row is committed).
  • If you don’t want to do that, you could use the Drop Down Container widget and create a custom drop down with the values from your table combined.

Hope that helps,