Use the Lookup Table Maintenance window to maintain the values in reference tables used in Synergetic.
Expand | ||
---|---|---|
| ||
To open the Lookup Table Maintenance window:
|
Lookup Table Maintenance window key fields and buttons
Fields
Field | Description |
---|---|
Table Name | List of available lookup tables. Scroll down and select the lookup table required. |
Table DataValues | For the selected table, the fields (columns) and records (rows) are displayed. Tip: You can use the Table Values field to search for terms within the selected lookup table. |
Active Records Only | For the selected table, select the Active Records Only field to display only records that have their ActiveFlag field (column) selected. In the example below , two the records , with codes 0000 and 0002, do with code 0001 does not have their its ActiveFlag fields field selected and so are it is not displayed. |
Buttons
Button | Description |
---|---|
Go to the first record in the Table Data area, for the selected table. | |
Go to the previous record in the Table Data area, for the selected table. | |
Go to the next record in the Table Data area, for the selected table. | |
Go to the last record in the Table Data area, for the selected table. | |
Create a new lookup table entry, for the selected table. | |
Save the changes made to the current record. | |
Undo the:
| |
Delete the selected record. | |
Load default records for certain tables. For example, you can load reference data for the following external systems:
|
...