Create dynamic table

In order to create an AJAX dynamic table, use the AJAX Dynamic Table Wizard. It is accessible from the MX AJAX Toolbox tab of the Insert bar (or MX AJAX Toolbox menu item from the Insert menu):

The AJAX Dynamic Table Wizard has three steps.

Configure the first step of the AJAX Dynamic Table Wizard as shown below:

1. In the Get data from drop-down menu select the source for the AJAX dynamic table data, either a database table or a recordset.

2. • If you are retrieving data from a table:
     
     
                                          

   • • Select the database connection to use for retrieving data.

     • Select the database table that stores the information you want to display in the AJAX dynamic table.

     • Select the table column that uniquely identifies each record.

   • If you are retrieving data from a recordset:
     
     
                                         

   • • Select the recordset that contains the information you want to display in the AJAX dynamic table.

     • Select the recordset column that uniquely identifies each record.

2. In the Detail page text box specify the site file that contains the associated form.

3. Specify the number of items displayed at once (per page).

4. The buttons in the lower part of the interface (they appear on all steps of the wizard) offer the next functionalities:

5. • With the < Back/Next > buttons you can navigate through the wizard's steps.

   • Click Finish to apply the wizard, when you are done configuring it.

   • Click Cancel to exit without the new settings to be applied.

   • The Help button brings you to this help page.

5. Click Next to continue configuring the wizard.

Configure the second step of the AJAX Dynamic Table Wizard as shown below:

1. All the columns in AJAX dynamic table are displayed in this grid, along with their properties.

2. Specify the header (label) for the current AJAX dynamic table column.

3. Specify the maximum number of characters that will be displayed in the current AJAX dynamic table column.

4. The Get value from radio group only shows if you are retrieving data from a table:

5. • Select the database table source (current table or look-up table) for the current AJAX dynamic table column.

   • Select the database table that stores the information you want to retrieve for the current AJAX dynamic table column.

   • Select the database table column that stores the values to be displayed in the current AJAX dynamic table column.

   • Select the database table column that uniquely identifies each record.

5. Click Next to continue configuring the wizard.

Configure the third step of the AJAX Dynamic Table Wizard as shown below:

1. Decide if to use a filter for the AJAX dynamic table or not.

2. All the columns in AJAX dynamic table are displayed in this grid, along with their filtering properties.

3. Select the form element to use for the current filter, or None if you do not want to use a filter for the current AJAX dynamic table column.

4. Select the filter type.

5. Specify the maximum number of characters that can be entered in the filter text box.

6. Select the table column by which you want the records to be initially ordered.

7. Decide if the sorting will be ascending or descending.

Once generated in page, this widget cannot be edited (regarding the server behaviors it generates). You can edit the Header labels in Design view though. If after generating it, you realize that you want to configure some settings differently, use the Undo command. Everything that was generated will be removed from page, and you can apply the wizard again, configuring it differently.

Related Topics