The examples in this section demonstrate how you might use the TreeView DataWindow.
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.
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.
Tables and database
Both examples use the employee, sales_order, sales_order_items, customer, and product tables in the PB Demo DB database.
TreeView DataWindows
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.
