Lookup Table Management

The Lookup Configuration tool allows you to update the contents of lookup tables, as well as setup which lookup tables are updatable.

Setting Up Updatable Lookup Tables
Each record within the section corresponds to a lookup table. The Lookup Table Name and Key Field text boxes correspond directly to the table name and key field of the actual lookup table.

The optional Display Order Field can be used to specify the field that controls the order by which lookup entries are listed.

The Auto-Increment Key Field checkbox is used to specify if the lookup table's key field is incremented automatically by the database software.

The External Connection field is used to specify that the lookup table is located in a database other than the EfficiencySpring database.

All lookup table records are stored in the lu_Lookup_Config table.

Updating Lookup Tables
Once a record has been created for a lookup table, you can edit its contents by using the Edit Current Lookup Table dialog box on the front page of the section. After selecting a lookup table, a screen will be displayed showing all of its contents for all of its fields. From here, entries can be added, updated, or deleted.

  Loading...