Lookup Table Maintenance Window

Lookup Tables allow users to select standard options when creating records in the system.  This makes the system easier to use, increases productivity, and ensure data integrity.  For example, if you are filling out a data field for "City" with the city name "Tallahassee", it is possible that it may be misspelled in some of the records.  This would cause the results of a search for the city of Tallahassee to be incorrect, as the misspelled records would not display.  If you select the city from a drop down list, it will be spelled the same each time, thus ensuring your data integrity.   When the Lookup Table Maintenance option is selected from the System Administrator Menu, a blank Lookup Table Maintenance Window is displayed.  See screenshot below.

To select a specific Lookup Type, click on the down arrow just below the "Select Lookup Type" to display the Lookup Types.  See screenshot below.

To add, edit, or delete a specific lookup type, simply select one from the drop down list.  The records for that lookup type will be displayed.  See screenshot below.

From this window you can add, edit or delete lookup records that appear in drop down lists throughout the system.  To add or delete records is done as in any other window in the system by using the Add or Delete buttons.  To edit a record, simply type over the old data.   WARNING: If you delete or change a lookup item that is that is used in other records in the system, it will change all records that use that lookup item.  Please be careful here.  This is the reason for System Administrators only having access to update this table.