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?
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.