Single Select Database

Single Select Database (SSDB) gives you the ability to create single select drop-down attributes that are based on database tables.

You use single select databases when the underlying lookup table exhibits a key-value relationship, and when one entity can be defined by one attribute and identified by one key column.

You can select only one value at a time from a drop-down list or a radio button group, depending on the display format that is selected while you create the attribute.

These tables must follow certain conventions.
  1. The table names must have a prefix: lkup.
  2. It must have at least two columns: a key column and a column that stores display values.
  3. It is recommended to have the key column with a primary key constraint to avoid repetition. Even if the lookup table that is pointed to is a view, ensure that the data in the view has unique records.
  4. It is recommended to not have more than three columns, where the third column refers to the relationship with another SSDB attribute. Having more than three columns in the lookup table renders the unused columns redundant.
  5. Set the Sort-by Column field to the same column as the Display Column, so that your Display Column values are visible when you select a column sort order.