New Lookup Table

Overview

The ability to add a lookup table to the iPDWeb system is available through the Lookup Table Window.

 

New Lookup Table

To add a lookup table to the system:

  • Click on the New Button.

  • Enter general information for lookup table including name, lookup table value data type, and question text.

  • Enter information for lookup keys, including name, key data type, and question text.

    • Check the Enabled box for Key 2 if using both lookup keys.

  • Enter key values.

    • Highlight desired lookup key in the Lookup Keys table.

    • Click on the Add button above the Key Values table to the right.

    • Enter values and select desired options from drop-down menu ("Equal To, Greater Than or Equal To, etc.).

    • Note that the added Key Values entries will appear at the borders of the Lookup Values table at the bottom of the window.

  • Enter lookup values in the Lookup Values table.

  • Click on the Save Button.

 

Notes

  • A user can create a new copy or version of an existing lookup table by clicking on the Copy or New Version Button.

  • To cancel the creation of a new lookup table click on the Cancel Add Button.