In some CRM-Systems (customer relationship management) they use seperate tables to store the key-value pairs for listboxes, radiobuttons and checkboxes.

The situation can be described as by: we have a customer table that contains a column named GENDER_UID -> this is resolved within a reference table calles UC_TEXT (unicode text). It is linked by the language code and the UC_UID. The link between the two tables is made via the LOOKUPVALUE function as followed:

Code-Sprache: JavaScript (javascript)

A detailed description on how it works can be found here: