This section provides you with two examples that demonstrate how you might use the TreeView DataWindow.
The two TreeView DataWindow examples are:
Data Explorer
The Data Explorer uses a TreeView DataWindow to display sales-related data in a Windows Explorer-like interface and allows users to update the data.
Data Linker
The Data Linker uses a TreeView DataWindow on the left for data navigation, linked to four DataWindows on the right for updating the data. The Data Linker demonstrates populating a TreeView DataWindow with data and linking each TreeView level to a separate DataWindow.
Both examples use the employee, sales_order, sales_order_items, customer, and product tables in the EAS Demo DB database.
The TreeView DataWindows are d_sales_report and d_sales_report2. Each TreeView DataWindow has three TreeView levels:
The first level (level 1) is the sales representative's name.
You create the first level using the TreeView DataWindow wizard.
The second level (level 2) is the name of the customer’s company.
You create the second level using the Rows>Create TreeView Level menu item in the DataWindow painter.
The third level (level 3) is the sales order ID.
You also create the third level using the Rows>Create TreeView Level menu item in the DataWindow painter.