You can access system lookup tables from the main Designer screen to add, rename, inactivate, or delete items.
1.On main Designer screen, from the Go to drop-down list, select Lookup Tables. The System Lookup Tables screen appears, as shown in the following image.
 System Lookup Tables Screen
2.Select the appropriate lookup table in the Show items belonging to drop-down list. If the lookup table has a hierarchical tree structure, another drop-down list appears, labeled Show items in node. If necessary, select the appropriate node in the Show items in node drop-down list to view the items that are listed within that item.
The items that have been added to the lookup table (or to the selected item within the lookup table) appear.
|
The following table describes the items in the System Lookup Tables screen.
Field
|
Description
|
Show items belonging to
|
Select the appropriate system lookup table containing the items you want to view.
|
Show items in node
|
Select the appropriate node (hierarchy level) where items are located.
Note: This field appears only in those lookup tables that can have the hierarchical tree structure.
|
Item Name
|
Enter a name for the item. This name appears to the end-user.
The maximum length is 50 alphanumeric characters.
|
Order
|
Enter an integer to indicates the order in which it appears to the user. Items with the same order are sorted alphabetically. For details, see Hierarchical Tree Structure.
Tip: Enter integers in increments of five so that you will have room to insert additional lookup table items if necessary.
|
Tree Position
|
Enter a four-character alphanumeric code that is unique among the items in the lookup table. For details, see Hierarchical Tree Structure.
Note: While you can enter the tree position in uppercase or lowercase, the tree position is saved in uppercase in the database.
|
Lookup Item List
|
Displays a list of items in the selected node of the lookup table with corresponding check-boxes to delete or edit the item.
|
edit
|
Click to change the name of the selected lookup table item.
For more details, see Editing System Lookup Tables.
|
delete
|
Click to delete the selected lookup table item.
Caution: Deleting lookup table items can cause the loss of associated data. If you delete a node, all of its sub-levels and their data entries are also removed. If your system is in production, consider inactivating lookup tables instead of deleting them.
For more details, see Deleting Lookup Table Items.
|
inactivate/activate
|
Click to inactivate or activate the selected lookup table item.
When you inactivate a lookup table item, users can see the item in all fields that reference the lookup table, but they cannot select it. Inactivated lookup table items appear differently than active items. For more information, see Inactivating Lookup Table Items.
|
|
