The data that a query retrieves from a database is called a result set. Typically, the results of a query are displayed in a report. Queries can also be used to dynamically populate forms. For example, you can dynamically populate a list box with selections, such as city names, based on one of the user's previous selections, such as a state name. For more information, see Using flat queries.
Hierarchical queries combine the result sets from several flat queries in a tree structure.
For more information, see Using hierarchical queries. All rights reserved.