Single-select Database attributes

This attribute type functions the same as a single-select attribute, except that the list of choices comes from a database table containing valid items. If the list of choices is relatively long, or could change, you should use the Single-Select—Database attribute type.

You can make a single-select database attribute dependent on the value in another field. For example, you could make the choices in a list of cities dependent on which state is selected.

This attribute type is not available for cell attributes.

When you create a single-select database attribute, you must specify the lookup table, and other information as described in the following tables.

Additional Basic Options fields

Single-select database attributes have the following additional basic options:

Field	Description
Filter database table name	A value to use to filter the dropdown list of table names for the Use values from this database table field. Only those lookup tables with the specified text in their table names are included in the list. If this field is empty, the list contains all lookup tables in the database.
Use values from this database table	Select the table that contains the values that you want to display to users.
Key Column	Select the primary key for the table.
Display Column	Select the database column that contains the values you wish to display on the form.
Sort-by Column	Select the column that determines the order of the list when it displays on the form.
Sort Order	Select Ascending or Descending, depending on how you want the list to display.
This field is dependent on the following column	Select the check box and specify the database column from the drop-down list. (This option is not available for global attributes.)

Additional Grid Options

Single-select database attributes have the following additional grid option:

Field	Description
Do Not Cache Lookup Values	Select the check box to update the values from which users can select every time the grid is saved or refreshed.

Additional Display Options fields

Single-select database attributes have the following additional display options:

Field	Description
Default Value	Select a default value for the attribute, or leave this field blank if you do not want to have a default value for the attribute. (The list contains all values in the database column specified in the Display Column field.)