Database Reference
In-Depth Information
TIP
If a field has only a few possible entries that won't change, typing the list di-
rectly in the wizard is easier. If a field has a lot of potential entries, or if the entries
will change often, you can link them to a table. (You might have to create a table
expressly for this purpose.) For information about creating lookup fields based on
another table, see “Allowing only values in other tables” later in this chapter.
2
Click
I will type in the values that I want
, and then click
Next
.
3
Leave the number of columns set to
1
, and click in the first cell in the
Col1
column.
4
Enter the following state and province abbreviations, pressing
Tab
(not Enter) after
each one to move to a new row.
BC
CA
ID
MT
OR
WA
6
5
Click
Next
.
You assign a name to the new field on this page.
SEE ALSO
For information about creating fields that can hold multiple values, see the
sidebar “Multivalued fields” later in this chapter.