System tables may be modified to add, edit and delete values. System tables are accessed from the settings menu and certain dynamic areas within the database such as the add item screen and the catalog record data screens. The following tutorial will address modifying system tables from the settings screen. System table values will be displayed in all modules for the organization.

Add Value to Table

1. Log in with a user name and password that has been granted access to Modify System Settings.
2. Click Settings on the menu on the left side of the home screen.
3. Select a Table using the Select Coded Table dropdown menu on the System Tables tab.
4. Enter the desired Value into the Add Table Entry field.
5. Enter a code into the Custom Code field.  This information is optional.
6. Click the Double Arrow button to add the value to the system table.
7. The message Data Saved will appear under the table.

Edit Table Value

1. Log in with a user name and password that has been granted access to Modify System Settings.
2. Click Settings on the menu on the left side of the home screen.
3. Select Table using the Select Coded Table dropdown menu on the System Tables tab.
4. Click to highlight the table entry to be edited. Information will populate into the Add Table Entry and Custom Code fields.
5. Edit the information in the Add Table Entry and/or Custom Code fields.
6. Click the Update button to save changes.
7. The message Data Saved will appear under the table.

Delete Table Value

1. Log in with a user name and password that has been granted access to Modify System Settings.
2. Click Settings on the menu on the left side of the home screen.
3. Select Table from the Select Coded Table drop-down menu on the System Tables tab.
4. Click to highlight the table entry to be deleted. Information will populate into the Add Table Entry and Custom Code fields.
5. Click the Delete button to save changes.
6. The message Sys code deleted will appear under the table.

Note: Table entries cannot be deleted if they are in use in any database table.

Note: Clear button clears table entry selection while preserving choice in Selected Coded Table.