Custom Lookup Maintenance Form and Create Lookup Type Form

This form is displayed when you select Custom lookup maintenance... from the Tools menu on the Script editor form and when you select the Maintain button on the Custom Dropdown Settings form. It enables you to add, amend, and remove the contents of lookup tables.

Lookup table: A collection of related Codes & Descriptions pairs. Select one from the drop-down menu.

Codes & Descriptions box: Contents of the selected Lookup table type

Note: Code and Description are the sole fields on the Create Lookup type form:

Code: Identifies a Codes & Descriptions pair

Description: Typically the purpose or scope of the pair, for example Payment methods

PUSH BUTTONS:

New: Enables you to create a new Lookup table type

Delete: Deletes the selected Lookup table type after a confirmation pop-up

Add: Enables you to insert a new Codes & Descriptions pair

Remove: Deletes the selected Codes & Descriptions pair with no further confirmation

Edit: Enables you to amend the Description

Note: The Add, Remove, and Edit buttons are enabled only when you select a Lookup table from its drop-down menu to populate the Codes & Descriptions box.

Confirm: Adds a newly created or updated entry to the Codes & Descriptions box

Cancel: Abandons an Add or Edit operation

Note: The Confirm and Cancel buttons are enabled only when you have selected either the Add or Edit button to create a new Codes & Descriptions pair or amend an existing pair.