Microsoft Office Tutorials and References
In Depth Information
A lookup table allows you to create a drop-down list of values in a field to
select from. So, if your company has a few standard hourly rates or per-use
costs for materials, customizing these fields can make your information entry
faster and also help prevent data-entry mistakes that can occur when you
enter all rates manually.
To customize a field, follow these steps:
1. Display a table with the column you want to customize.
You display tables by choosing View
Table and selecting one from the
list that appears.
2. Right-click the column heading and choose Customize Fields from the
shortcut menu that appears.
The Custom Fields dialog box appears, as shown in Figure 8-5.
3. Click the Lookup button.
The Edit Lookup Table dialog box appears, as shown in Figure 8-6.
4. Enter a value (if you’re filling in a cost field, this would be a dollar
amount) in the Value column.
5. Enter a description (for example, plant worker or engineer for the
category of resource charged at this rate) in the Description column.
You can use
cost field if