Working with Multi-Value Lookup Fields

In Chapter 1 we introduced you to the concept of complex data. Access 2010 includes a feature (first introduced in Access 2007), called Multi-Value Lookup Fields, to handle complex data. The purpose of lookup fields, as you just learned, is to display one value in a field but actually store a different value. For example, a lookup field could store the company ID in a field for an invoice but display the company name to the user for easier data entry on a form or to show the name on a printed invoice report. Lookup fields in this scenario take the guesswork out of trying to remember a specific company ID number.

Multi-Value Lookup Fields take this concept a step further by allowing you to store multiple values ...

Get Microsoft® Access® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.