Creating a Multi-value field in Access 2010

With so much collaboration in today’s business world, we often assign two or more people to the same project. In previous versions of Access, you had to enter separate records for each person to that project. Not anymore! Access has now included a multivalue field in the database. Is it hard to set up? Not at all. For example, in your database you already have a table listing the employees. You will want to create a separate table for your projects. In this projects table, you will have the fields of Project Id, Project Name, Description, Due Date, and Employees.

Open your table Design View and select the Employees field. For the data type, click on the drop down arrow and choose Lookup Wizard.

  1. It is now a simple matter of following the steps of the wizard. This is the opening screen. You can choose to either look up the information that you want in another table in the same database or you can choose to type in your own list. Click the Next button.
  2. In the second Screen, you simply choose the table you wish to use. Then click the Next button.
  3. The third screen allows you to choose the fields that you want to see in the drop-down.
  4. The fourth screen allows you to sort your list by whatever field you choose. You can sort by either Ascending or Descending order.
  5. In this screen you can see how your drop-down list will look to your users. If needed, you can also resize the column width by dragging the right edge of the column border.
  6. This is the final screen and be sure to put the checkmark in Allow Multiple Values.

You’re done. Now when you switch back to datasheet view of your table and you tab into the Employees field, you will see the drop-down arrow to click. Your list of choices will be displayed.

Simply click on the names of the employees that are working on this project and then click okay.

Finish adding your information to your record and when you have moved to another record, the datasheet will look like this.

Now both names of your participating employees are included in this one record.

To hear about the latest Office 2010 news, blogs, and training, subscribe to our newsletter. Click here to subscribe.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.