Build master list

To create the first list, displaying the records in the master table, you have to use the NeXTensio List Wizard. The list will be displayed in the master_list file. To create it, follow the instructions below:

1. Open the master_list file in Dreamweaver.

2. Open the NeXTensio List Wizard from the MX Kollection tab of the insert panel. Configure the wizard as follows:

3. • Use the connection defined at the beginning of the tutorial, and the company_com table. Set the form page  to the master_form file.

   • In the second step, the only available fields are name and address. Leave them at their default setting.

   • You can now click on the Finish button to apply the wizard, and thus add all elements into the page.

3. At this point, the company list is created, but its missing a link to the associated contacts (the detail list).

4. To add this missing link, create a new column at the list's end. Right click in the last table column, select the Add new Rows and Columns option, and set it to add a new column.

5. In this new column, type details, and through the Make Link dialog box, set it to point to the detail_list. Also, you must send the master record A database row from the master table. The master table is defined by a one-to-many relation to another table (the detail table)'s id, so only the associated contacts will be displayed. Press the Parameters button, and add the id_com parameter, having the dynamic value of the id_com recordset field:
   
   
    

6. Save the page and upload it to the server. If you preview it in the browser, it will display a list similar to the image below: