|
|
|
|
The Nested Repeat Region is a part of MX Looper that allows displaying data from related tables, indicating the actual relationship. It comes with two components:
The Create Nested Repeat Region Wizard that builds the entire region for two dependant tables, displaying records from the detail table under the corresponding master element. It only requires the tables and relation field in order to add all required elements to the page.
The Nested Repeat Region server behavior that allows achieving the same results, but you must define the recordsets to retrieve data and the repeat region for the master element manually.
In this 'how to' tutorial you will learn how to combine the use of the wizard and the server behavior to create nested repeat lists with more than 2 levels. Before completing this tutorial it is advisable to read the user manual sections regarding the Create Nested Repeat Region wizard and server behavior.
The product needed to complete the tutorial is MX Looper, either separate or as part of the MX Kollection 3 bundle.
Before starting work on the tutorial, make sure you have a correctly defined Dreamweaver site, and access to a database server. The site will contain only one file - the site index.
The database to retrieve the three region's levels has the following
structure:
Note: The database diagram in the image above was built with MX Query Builder (also referred as QuB) to better illustrate the database structure. You do not need to build it in order to complete this 'how to' tutorial.
The database dump for the site can be found inside the downloaded package, in the \tutorials\_HOW_TO\Cascaded nested repeat region\db\ folder, as sql and mdb files. Import these files into an existing database or create a new one.
The last action you must take before starting the actual work is to
create a Dreamweaver database connection.
Open the site index and configure one, as shown in the image below (remember
to use your actual server information):
If all prerequisites are met, you can move on and start creating the site.