The values displayed in these columns are key values and are required. Key values must be unique. For tables with one key value, each definition must have a unique key. For tables with multiple key values, the combination of the key values must be unique.
The splitter bar is a special tool that lets you keep the columns to the left visible regardless of how far right you scroll. This tool is particularly helpful when working on a table with many columns.
Note that when activating the splitter, a gray vertical line is displayed. A complete display of the list is available on either side of the line. You can move the line to the left or right to resize either list. You can also scroll left or right within each list.
These fields are used when the possible values are limited to a specific set. Often times, these lists link back to another table. For example, when specifying a customer value, you must select a department from a list previously defined in the Department Maintenance table.
Spin controls are used exclusively for numeric values and have small up and down arrow buttons to the right of the control. To increase the value, click the up arrow; to decrease the value, click the down arrow. Spin controls are provided strictly as a convenience. You can also manually enter a value in these fields.