To change the caption of a table, click on [Caption] box to make the necessary change.

Note: If you want to use special characters, use HTML entities such as "&#euro;", or you can enter unicode caption using Unicode Property Editor, see Tools for details.

Specify a filter (WHERE clause) for the table. Click the [...] button in [Filter] column, the Filter Editor will popup. Enter your filter, you can drag the field names from the left pane to the editor, the SQL identifier quote characters will also be added for you automatically.

Note: The filter must be a valid VB/C# string as the WHERE clause will be concatenated to the SQL string. For example, "State = 'CA'".

Specify the sort fields (ORDER BY clause) for the table. Click the [...] button in [Sort] column, the following dialog box will popup. You can choose up to 6 fields, in either ascending or descending order.

Enable/disable Inline Add function for the table. Inline Add allows users to add a record within the List page. Default is disabled.

Enable/disable Grid-Add function for table. Allows users to add multiple records to the table. Default is disabled.

If the table is a detail table (in master/detail relationship), Enabling this option also enable Master/Detail-Add.

Note: From ASP.NET Maker 9, Grid-Add supports adding/deleting rows to/from the grid using JavaScript. Newer versions of browsers are required.

Enable/disable Grid-Edit function for table. Grid-Edit allows users to edit multiple records within the List page. Default is disabled.

If the table is a detail table (in master/detail relationship), Enabling this option also enable Master/Detail-Edit.

Note: From ASP.NET Maker 9, Grid-Edit supports adding/deleting rows to/from the grid using JavaScript. Newer versions of browsers are required.

Specifies if the List page requires search criteria. Default is disabled.

Notes:

1. If enabled, the List page always requires search criteria. When the page is initially loaded, no records will be displayed until searching is done. (Remember to enable Quick Search, including Extended Quick Search, or Advanced Search or both. See below.)
   
   
2. If a record is added but the new record does not meet the search criteria (or there is no search criteria yet), the record will not appear in the List page. So this option is best for tables which are for browsing only.

Specifies if the number of detail records for the master record should be displayed. Default is disabled.

Notes:

1. Applicable to master tables with master/detail relationships defined in ASP.NET Maker only, see below.
   
   
2. If the detail table is a report, this feature is NOT applicable, there will be NO detail record counts for the detail report.
   
   
3. The counts are retrieved by using a subquery for each detail table. The more detail tables, the more performance penalty. You should enable this feature only if it is really required.

If enabled, a View page for the table will be generated (for displaying a record). Default is enabled.

Note: The table must have primary key or this setting will be unchecked during generation.

If enabled, an Add page for the table will be generated (for adding/copying a record). Default is enabled.

Note: The table must have primary key or this setting will be unchecked during generation.

If enabled, Add page will be generated and "Copy" links will be generated for record(s) in List/View page (for copying). Default is enabled. (If this setting is enabled, the "Add" setting is also enabled by default as copying requires the Add page.)

Note: The table must have primary key or this setting will be unchecked during generation.

Enable/disable CAPTCHA function for the Add page. Default is disabled. (CAPTCHA requires that the user type the letters or digits of a distorted image before submitting a form to prevent automated software from posting spam to your ASP.NET application.)

Notes:

1. CAPTCHA function requires CAPTCHA extension, click Tools->Extensions from the main menu to enable. Also see Third-party Tools.
2. CAPTCHA function is not applicable to Inline-Add/Copy.

Enable/disable confirmation function for the Add page. Default is disabled. If enabled, there will be a confirmation step in the Add page, users will be able check their input before actually inserting the record.

Note: Confirmation function is not applicable to Inline-Add/Copy.

If enabled, an Edit page for the table will be generated (for updating a record). Default is enabled.

Note: The table must have primary key or this setting will be unchecked during generation.

Enable/disable CAPTCHA function for the Edit page. Default is disabled. (CAPTCHA requires that the user type the letters or digits of a distorted image before submitting a form to prevent automated software from posting spam to your ASP.NET application.)

Notes:

1. CAPTCHA function requires CAPTCHA extension, click Tools->Extensions from the main menu to enable. Also see Third-party Tools.
2. CAPTCHA function is not applicable to Inline-Edit.

Enable/disable confirmation function for the Edit page. Default is disabled. If enabled, there will be a confirmation step in the Edit page, users will be able check their input before actually updating the record.

Note: Confirmation function is not applicable to Inline-Edit.

Check if the record is changed by other user before updating the record.

Notes:

1. Since processing of current data for later comparison is required, using this feature will increase the time required to load the page. For better performance only the first hundreds of bytes of the BLOB fields are processed by default, but there are chances that change of BLOB data is not detected (if the first nth bytes are not changed). You can increase the number of bytes in Advanced Setting, if you want to process all bytes, enter 0.
   
   
2. You can use the Row_UpdateConflict server event (see Server Events and Client Scripts) to resolve the conflicts according to your business logic by code.

If enabled, a Delete page for the table will be generated (for deleting record or multiple records). Default is enabled.

Note: The table must have primary key or this setting will be unchecked during generation.

If enabled, a Multi-Update page for the table will be generated (for updating multiple records). Default is disabled. With this feature you can select multiple records in the List page and update all records at the same time. You can select fields (see Field Setup page) to be included in the Multi-Update page.

Note: The table must have primary key or this setting will be unchecked during generation.

If enabled, Quick Search panel (including Extended Quick Search) will be generated with the List page. Default is enabled.

Note: Quick Search searches text fields and optionally numeric fields only. These fields are selectable in Field Setup page. You may want to hide the Quick Search form for tables that do not have searchable fields.

If this setting is checked, the search criteria in the search result (List page) will be highlighted. Default is disabled.

Note: The highlight style can be modified by customizing the CSS stylesheet.

If audit trail for a table is enabled, when an user add/copy/edit/delete a record or login/logout, the related information will be logged in a log file or in a database table.

If enabled, when an user add a record, an email will be send to pre-set recipient email address(es). Default is disabled.

If enabled, when an user edit a record, an email will be send to pre-set recipient email address(es). Default is disabled.

If enabled, when an user delete a record, an email will be send to pre-set recipient email address(es). Default is disabled.

Specifies the page captions of each page in the Multi-Page. Click the [...] button and enter the page captions and click [OK] to save.

If page captions are not specified, "Page n" will be used by default. To add a page, go to Field Setup page, specify the page number for the fields in the page first.

Note: If you want to use special characters, use HTML entities such as "&#euro;", or you can enter unicode caption using Unicode Property Editor, see Tools for details. If you use multi-language project, you must use the Unicode Property Editor.

Specifies if Multi-Page is enabled for Add page.

Specifies if Multi-Page is enabled for Edit page.

Specifies if Multi-Page is enabled for View page.

Specifies if Multi-Page is enabled for register page. This setting is only available for the user table specified in Security Settings.

Specifies the return URL after a new record is added.

Note: The URL must be a valid VB/C# expression. If it is a string, it should be double quoted.

Example 1
If you want to redirect user to a custom page, enter:

"MyPage.aspx" (Note: Includes the double quotes).

Example 2
If you want to pass field values, enter: (e.g. VB)

"MyPage.aspx?xxx=" & ew_UrlEncode(<Table>.<Field>.DbValue)

e.g. "MyPage.aspx?ID=" & ew_UrlEncode(Cars.ID.DbValue)

Example 3
If you have just added a master record and want to go to Grid-Add page of the detail table, enter: (e.g. VB)

"<DetailTable>list.aspx?a=gridadd&showmaster=<Table>&<KeyField>=" & ew_UrlEncode(<Table>.<Field>.DbValue)

e.g. "OrderDetailslist.aspx?a=gridadd&showmaster=Orders&OrderID=" & ew_UrlEncode(Orders.OrderID.DbValue)

Example 4
If you have just added a master record and want to go to Add page of the detail table, enter: (e.g. VB)

"<DetailTable>add.aspx?showmaster=<Table>&<KeyField>=" & ew_UrlEncode(<Table>.<Field>.DbValue)

e.g. "OrderDetailsadd.aspx?showmaster=Orders&OrderID=" & ew_UrlEncode(Orders.OrderID.DbValue)

Specifies the return URL after a record is edited.

Note: The URL must be a valid VB expression (or C# expression, depends on language setting of your project). If it is a string, it should be properly quoted. Also see examples above.

Specifies the return URL after an user is registered. This setting is only available for the user table specified in Security Settings.

Note: The URL must be a valid VB expression (or C# expression, depends on language setting of your project). If it is a string, it should be properly quoted. Also see examples above.