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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
