Use the Edit Lookup Table dialog box to create, review, or revise a lookup table that's associated with a custom field. The lookup table makes it possible for you and other users to choose from a list of preset values rather than typing them. The lookup table is also referred to as a "value list." In the Edit Lookup Table dialog box, you can:
-
Specify preset values for custom Cost, Date, Duration, Finish, Number, Outline Code, Start, and Text fields.
-
Set a default value for the custom field.
-
Establish the order in which values in the lookup table should appear.
-
Specify whether additional items can be added to the lookup table through data entry.
-
Create the code mask for an outline code.
Dialog box location
In Project 2016, 2013, and 2010: on the Project tab, click Custom Fields and then click Lookup.
In Project 2007: on the Tools menu, point to Customize, and then click Fields. Click Task, Resource, or Project. In the Type box, click the custom field type, and then click one of the custom fields in the Field box. Click the Lookup button. If you have the required permission to edit enterprise fields, the dialog box name is Edit Lookup Table. If not, the name is View Lookup Table.
Details
Code mask section
This section is only available for outline codes.
Code preview Displays a sample of the outline code as it would appear, using the sequence, length, and separator defined in the Code Mask Definition dialog box.
Edit Mask Click this button to open the Code Mask Definition dialog box, in which you can set up the format and character sequence for the custom outline code.
Lookup table section
Toolbar buttons for all custom fields
Cut Row 
Copy Row 
Paste Row 
Insert Row 
Delete Row 
Move Up 
Move Down 
Toolbar buttons for outline codes
These toolbar buttons appear only for outline codes.
Outdent 
Indent 
Show Subcodes 
Hide Subcodes 
Show All Subcodes 
Lookup table definition
Row Indicates the row number in which the value is being entered.
Value Enter each of the lookup table values you want in a separate row.
Description Enter an optional description of each lookup table value you entered. This description appears next to the value in the lookup list for the field.
Display indenting in lookup table Available only for outline codes. Select this check box if you want the various levels of the outline code to be distinguished by indenting in the lookup table. By default, this check box is selected.
Use a value from the table as the default entry for the field Select this check box if you want one of the values from the lookup table to be entered automatically unless another entry is made. Select the check box, select the default value you want from the table, and then click the Set Default button. By default, this check box is cleared.
Display order for Lookup table section
By row number Select this option if you want the values in the lookup table to appear in their row order. This is the default option. You can rearrange the rows using the Move Up and Move Down buttons.
Sort ascending Select this option if you want the values in the lookup table to appear in ascending order, for example, from A to Z or from 0 through 9.
Sort descending Select this option if you want the values in the lookup table to appear in descending order, for example, from Z to A or from 9 through 0.
Data entry options section
Allow additional items to be entered into the fields Select this check box if you want to allow users to add data other than the values in the lookup table. If you allow this, those new values will become part of the lookup table.
Allow only codes that have no subordinate values Available only for outline codes. Select this check box if you want to allow user entry of codes only if they are at the lowest outline level.
Import Lookup Table
Click this button to open a dialog box that you can use to select the project or template and the custom field (including outline codes) within the project or template that contains the lookup table you want to import into the current custom field.
