Help:Data Dictionary:Value Lists
The Value Lists page is used to create list of values that can be associated with attributes. For example you may create a list of values for "Gender" with values: Male, Female etc... Value lists can be static, in which case the values are defined in the "Value list entries" section of this page. Or, if a "Table name" is defined, the list of values are fetch from a database table.
|Value list name||Name of the Value List. This name must be unique.|
|Table name (optional)||If provided, the values of the Value list will be taken from this database table instead of the "Value list entries" definition. This database table is expected to have the following fields:
|Save value lists||Save changes to the value lists. When creating a new value list, this save is required to be able to use the value list for an Attribute. Alternatively you can use the "Save all" action button to save all changes made to the solution.|
Value list entries
|Value||Value of the Value List option. This value will be stored in database when the option is selected. Values must be unique.|
|Text||Text displayed in the user interface for this option.|
|Dependency value||Dependency value allows creating dependency between 2 attributes having different value lists. There is no limit to the number of attributes linked together with a dependency.
For example in order to create a Country / State / City dependency, proceed as follows:
Create a "City" value list, where values are city codes, dependency values are associated state code and Text are city names. In order to ensure city codes are unique across all countries, it is a good idea to prefix **them with the country/state code. For example:
Then you can use these value lists by creating 3 attributes (Refer to Entities Attributes for details) as follows: