Create Multi-Value Fields in Access 2010


show more Creating multi-value fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating multi-value fields

When using Lookup fields, you can also make them multi value so that the user can pick several options off of the list. Let's add a Multi Value Lookup field to the Customer table. Right-click on Customers and choose Design View. Scroll down and click on the gray box next to WebPage and then choose Insert Row to add a row above it. In the Field Name, enter Type. Now TwoTrees Customers fall into two categories: Retail stores and Restaurants. In a few cases, our customers both buy our olive oils as food ingredients and sell the bottles out in front.

We're going to make a field with a dropdown, allowing the user to pick one, the other, or both. Click on the Data Type and choose Lookup Wizard. Click on "I will type in the fields that I want" and click Next. Here's where we enter the values for the list. The first will be Retail, and the second will be Restaurant. Click Next. If you wanted to change the label, you could. If you want the user to only be able to select from these...

Creating multi-value fields
Video duration: 2m 19s 3h 30m Beginner

Viewers:

Creating multi-value fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...