Working with Multi-Value Lookup Fields

In Chapter 1, I introduced you to the concept of complex data. Access desktop databases include a feature 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 in a single lookup ...

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

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