ACCESS DEVELOPMENT
Design and Code with Multi-Valued Fields in Microsoft Access 2007
Find out how to get the most out of this new feature.
Subscribers: Sign-in to activate download link -- Get example queries that demonstrate how you can use multi-valued fields.
About this Article:
Multi-valued fields in Access 2007 make it easier to build user interfaces with many-to-many relationships. But to use this new feature effectively, you need to know when to use it and how it works in both queries and code.
Peter Vogel (MBA, MCSD) is a principal in PH&V Information Services. PH&V specializes in system design and development for client-server and intranet systems. Peter has designed, built, and installed COM and COM+ systems for Bayer AG, Exxon, Volvo, Christie Digital, and the Canadian Imperial Bank of Commerce. He is the editor of several newsletters, wrote The Visual Basic Object and Component Handbook (Prentice Hall), and is currently working on a book on using XML in Distributed Applications (APress). Peter teaches for Learning Tree International and wrote their ASP.NET and technical writing courses. His articles have appeared in many programming magazines, in the Microsoft Developer Network libraries, and are included in Visual Studio.NET. Peter also presents at conferences around the world, including Advisor Summit.