Code lists

Code lists can be used to suggest or restrict the values that are added to fields. Ensuring that field values are aligned across a database can improve search results.

There are three different types of code list:

  • Selected from - you can only use the items on the list.

  • Suggested from - you can either use an item on this list or enter your own value.

  • Security Classification Code - this type of code list controls access to records.

    Attention: You can select security classification codes that deny you further access to the record after you save it.

If you want to find a field value that is no longer included in a list, use a query rather than Find or Select. In a query, you are allowed a 'free entry' so you can specify non-code list values.

Note: If the list does not contain the item that you want, you can add it by selecting Code Lists from the Edit menu (provided you have the required permissions as a user).