Lookup Tables

To access this screen:

• Project Settings screen >> Lookup Tables.

A lookup table matches one input value to one return value. Use it when you need DTS to convert a value from one format into a numeric value for a calculation.

You use lookup tables in the Production Field Formula Builder. The formula checks the input value against the table and returns the matching value.

To create a lookup table (list type):

1. Display the Lookup Tables screen.

2. All predefined lookup table appear in a list on the left of the screen. You can also use the toolbar to create a New table, Copy a table (say, to make something similar), Delete or Edit a table.

3. If you're creating a new lookup table, overtype the default name.

   For the selected lookup table specification.

4. In Condition Type, select the data type for the input values. Valid values are Integer, Float, Duration, Date, and Text. All entries in the Condition column must use this type.

5. In Return Value type, select the data type for the returned values. All entries in the Value column must use this type. The default value is Integer.

6. In the grid, enter the Condition values to check.

   For each Condition, enter the Return Value that must be returned when a task field matches that Condition.

   Add as many Condition and Return Value pairs as you need.

7. Click OK to save and apply your changes.

8. Save your project.

Related topics and activities:

• Production Fields