Feature

• Access 2007 allows users to enhance the concept of lookup data fields and types through the creation of multi-value field lookups. Multi-value fields can be created to handle complex data lookups or databases that are connected through a primary key field.
  
  

Function

• Multi-value field lookups can be stored in a single lookup field. Access 2007 allows users to design forms and queries that contain input boxes to create single lookup fields. Multi-value field lookups are especially useful when creating or maintain an inventory management system.
  
  

Considerations

• Most users use caution when using multi-valued fields of Access 2007. Microsoft has included multi-valued fields to integrate with Microsoft Sharepoint. To use the full functionality of Access 2007 multi-value fields on a network, the software is combined with Microsoft SQL to build complex applications.