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 could change, consider using 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 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.
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 have the following additional grid option:
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 have the following additional display options:
Additional 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.)
Copyright IBM Corporation 2014. All Rights Reserved.