How to Create an Access 2007 Multi-Column Lookup List

By eHow Computers Editor

Rate: (1 Ratings)

A multi-valued lookup column is a new feature in Access 2007. Previous versions of Access allowed only one value to be stored in a database field. A multi-valued lookup column will allow you to choose more than one item in a list. The following steps will show how to add a multi-valued lookup column in Access 2007.

Flag Article

Instructions

Difficulty: Moderately Challenging

Step1

Start Access 2007 and click the Microsoft Office Button. Click on the Open line item to bring up the Open dialog box and select a database that has a table already created. Open the database and look in the Navigation Pane for the table in which you wish to create the lookup column. Double-click the table icon to open the table in Datasheet view.

Step2

Look on the Datasheet tab for the Fields & Columns group. Click on the Lookup column to start the Lookup Wizard. You should use the Lookup Wizard to create a multi-valued lookup column whenever possible because it greatly simplifies this process.

Step3

Choose between using the lookup column to look up values in a data source or entering the values directly. For a multi-valued lookup column, you generally want to display values from the appropriate data source.

Step4

Select the fields under the Available Fields list that you want in your lookup and click on the button to move them to the Selected Fields list. Select the sort fields and adjust the column widths as usual.

Step5

Mark the check box that asks if you want to store multiple values for this lookup and click on the Finish button to complete the wizard.