Single-Select - Database attribute types

The Single-Select - Database attribute type functions like the Single-Select attribute type, except that the list of choices comes from a database table that contains valid items. If users can select from a list of options that is relatively long, or might change, consider the Single-Select - Database attribute type.

You can make a Single-Select - Database attribute dependent on the value in another field. For example, you might make the choices in a list of cities dependent on which state is selected.

You can also define form attribute rules for this attribute type. The rules make another field visible if the user selects a certain value for this attribute. For example, if the user selects Canada or France from a single-select database attribute that contains various countries, you might make a Province attribute visible elsewhere in the form.

Note: This attribute type is not available for cell attributes.

When you create a Single-Select - Database attribute, you specify the lookup table and other information as described in the following tables.

Additional Basic Options fields

Single-Select - Database attributes also have the following basic options.

Table 1. Options for Single-Select - Database attributes
Field	Description
Filter database table name	A value to use to filter the drop-down 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 want to display on the form.
Sort-by Column	Select the column that determines the order of the list when it displays on the form.
Ascending / Descending	Select the sort order for the list.
This field is dependent on the following column	To make the values that display in this list dependent on the selection that the user makes for another field, select the check box and specify the database column from the drop-down list. This option is not available for global attributes.

Additional Grid Attribute Options field

Single-Select - Database attributes also have the following grid option:

Table 2. Grid options for Single-Select - Database attributes
Field	Description
Do Not Cache Lookup Values	Select to update the list of options every time a user saves or refreshes the grid.

Additional Display Options fields

Single-Select - Database attributes also have the following display options:

Table 3. Display options for Single-Select - Database attributes
Field	Description
Default value for the field	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 that is specified in the Display Column field.)