Apply the Nested Repeat Region Wizard from the MX Kollection tab of the Insert panel. This way, all continents will be displayed, each one with its own countries (of course, not in the wanted layout yet).
Select the conn_category_items database connection previously defined.
For the master table, select the continent_con one.
Select the primary key of the master table, namely id_con.
Select the name_con column to be displayed as continent names (categories).
For the detail table, select the country_cnt one.
Select the foreign key in the detail table, namely idcon_cnt.
Select the name_cnt column to be displayed as country names (items).
Click Next to move on to the second step of the wizard.
Configure the second step of the wizard as shown
below:
Choose the Sub-table repeat style.
Click Finish when you are done configuring the wizard.
The page in Dreamweaver,
in Design view, should look like
this (for the PHP server model):
Note: If the translator does not look right, save the page,
close it, and reopen it.
Press F12
to preview the page in browser (after saving and uploading it to the server),
and see the current continents/countries display:
On your way to the wanted layout, there are some
changes you need to perform back in the Dreamweaver
page. First, remove the Repeat Region server
behavior from the Server Behaviors tab of
the Application panel. Select it (single-click)
and press the Minus (-) button on the top
left:
Click inside the translator in page (for example,
click the dynamic text on the first table row), and then select the <table> tag in the Tag
Selector. Change the border thickness from 1
pixel to 0 pixels:
Press Ctrl+A to select all the elements in page, and then apply the Looper Wizard from the MX Kollection tab of the Insert panel. This is needed because after removing the Repeat Region server behavior, only the first continent with its countries is displayed.
Configure the wizard interface as shown below:
Since you want to display continents (categories) in a certain number of columns, select the Horizontal looper type.
Select the master1continent_con recordset to loop by. This recordset was created by the Nested Repeat Region Wizard.
Check to display all the records (continents with their countries), in 3 columns.
Click OK when you are done configuring the wizard.
The Looper Wizard adds a new table at the outside of the existing one. There are a few things that you should change regarding this table:
Once again, click inside the translator in page (the dynamic text on the first table row). Then select the first <table> tag in the Tag Selector. The second <table> tag corresponds to the initial table (that had its border thickness changed), and not the one added by the wizard.
Configure the following table properties in the Property Inspector:
Set the cell padding to 3 pixels.
Set the cell spacing to 3 pixels.
Set the border thickness to 0 pixels.
Then click the <td> tag in the Tag Selector, also corresponding to the first table. Set its vertical alignment to Top:
After following all the steps
above, save the page, upload it to the server, and press F12
to preview it in browser:
