Lookup Table Maintenance window
Use the Lookup Table Maintenance window to maintain the values in reference tables used in Synergetic.
Lookup Table Maintenance window key fields and buttons
Fields
Field | Description |
---|---|
Table | List of available lookup tables. Scroll down and select the lookup table required. |
Table Values | 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 the records with code 0001 does not have its ActiveFlag field selected and so 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. A new blank record is created at the bottom of the grid and the cursor is moved into the first field so that you can enter the details for the new record. Tip: You can load default settings for some tables. | |
Save the changes made to the current record. | |
Undo the:
| |
Delete the selected record. Note: Deleting records from certain tables can cause some functions within Synergetic to perform incorrectly. However, deleting records does not necessarily delete the data from any records it is stored against. Tip: Alt+d deletes a highlighted record, while Alt+y confirms that you want to delete the record. These shortcuts are useful when deleting multiple entries. | |
Load default records for certain tables. See Loading lookup tables for external systems. For example, you can load reference data for the following external systems:
|