Single-Select - Database attribute types
The Single-Select - Database 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, 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 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:
Options for Single-Select - Database attributes
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 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.
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:
Grid options for Single-Select - Database attributes
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:
Additional display options for Single-Select - Database attributes
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.)
Copyright IBM Corporation 2013. All Rights Reserved.