Nested Repeat Region Wizard

The Nested Repeat Region Wizard can display records from two related tables (master and detail tables) in an organized manner. The wizard uses the foreign key to determine which detail record belongs to which master record, and lists them accordingly.

It will add all the required elements into the page, like tables, recordsets and server behaviors. You can also create these elements by hand, and then use the Nested Repeat Region server behavior to achieve the same result.

The Nested Repeat Region Wizard is accessible from two locations:

• The MX Kollection tab of the Insert bar.
• The Application panel, Server Behaviors -> + -> MX Kollection -> Dynamic Lists -> Nested Repeat Region Wizard.

This wizard has two steps. Instructions about the correct configuration are given below.

To set the dialog box options for the first step of the wizard, read the instructions below:

1. In the Connection drop-down menu select the database connection defined for your site; if you don't have a connection yet, you can use the Define button and create one now.
2. In the Master table drop-down menu select the table containing the master records. This drop-down menu displays all the tables retrieved from the connection you selected at the first step.
3. In the Primary key drop-down menu you must select which field contains the primary key in the master table. It automatically selects the first field.
4. In the Display Value drop-down menu select the field that stores the names you want to be displayed.
5. In the Detail table drop-down menu select the table that contains the records linked to the ones in the master table.
6. In the Foreign key drop-down menu select the detail table field which contains the relation to the master table.
7. The Display value drop-down menu allows the choosing of a suitable field for display instead of the foreign key.
8. The five buttons in the lower part of the interface offer the following functionalities:
   · With the < Back / Next > buttons you can navigate through the wizard's steps.
   · Click Finish when you are done configuring the wizard.
   · Click Cancel to exit without the new settings to be applied.
   · The Help button brings you to this help page.
   These buttons appear on all three interfaces of the Nested Repeat Region Wizard.
9. Click Next to continue with configuring the wizard.

To set the dialog box options for the second step of the wizard, read the instructions below:

1. In the Repeat style radio group select the method by which the detail records will be displayed: List (comma-separated list) or Sub-table (tree-like structure).

2. The image below this radio group gives a preview of how the list will look like. In the image above, you can see the sub-title style, and in the next image, the list style:
   
   
    

3. Click Finish when you are done configuring the wizard.

In the Dreamweaver page, the result should look something like this:

Note: If two nested repeat regions are used on the same page, you must create a separate recordset for each one. If you try to use the same recordset for both you will be prompted with an error message.