ACCESS DEVELOPMENT
Build Hierarchical Data in Microsoft Access with Shaped Recordsets
Find out how you can make your life (and your code) much simpler.
Subscribers: Sign-in to activate download link -- Get a class module for creating shaped recordsets.
About this Article:
Sometimes your data isn't only relational; it's hierarchical with parent-child relationships. Using shaped recordsets lets you work with hierarchical data more easily. Loading a TreeView is a snap, for instance, with a shaped recordset and the class modules in this article.
Leigh Purvis Leigh is an experienced developer in the United Kingdom and Microsoft Access MVP who operates as "Database Development," creating applications for various industries, particularly the legal sector. He's a frequent contributor on the Utter Access and Experts Exchange forums.