Administrator: Rave Reviews Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

Modify the Table

A MultiValue field lets your users select more than one answer to a question.  You can use a MultiValue field in this database to document why a movie was archived.

 

Try it: Add a MultiValue field

Enter a new field: Status.

Data Type: Lookup Wizard.

Enter the list:

  Damaged

  Lost

  No Sale

  Do NOT Re-image

 

Edit the Lookup Properties

Allow Multiple Values: Yes.

Allow Value List Edits: Yes.

Now, your users can choose several values, and they can add to the value list.

 

Save your changes and close the table.

Table Tools -> Design->Insert Lookup Column
 
   

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements

  2.4.3. Create and modify multivalued fields : NOTE: Issue with upsizing; could cause problems