Database Reference
In-Depth Information
Multivalued fields
Usually, you will be able to build database tables in which each field holds only one
value. However, sometimes you might need to store more than one value in a single
field. For example, in a Projects table, you might need to store multiple employee
names in a Team field.
To set up a multivalued field that restricts values to those in a table:
1
Create a new lookup field, and indicate on the first page of the
Lookup
wizard that
you want to look up the values in a table.
2
On the second page, select a table from the list.
3
On the third page, select the fields you want to include.
4
On the fourth page, indicate any sorting.
5
On the fifth page, make any necessary adjustments to the column width.
6
On the last page of the wizard, enter a name for the field, and select the
Allow
Multiple Values
check box.
When the table is open in Datasheet view, clicking the field's arrow displays a list from
which users can choose entries by selecting their check boxes. Clicking OK then dis-
plays the selected values in the field.
TIP
Think carefully about how your database will be used before creating multivalued
fields. They are not easy to change, and they can produce unexpected results in filters
and queries.
