Table Setup

After loading the database, the tables and views will be shown in the database treeview on the left pane (database pane). Click on the [Tables] or [Views] or [Custom Views] or [Reports] node to go to the Table Setup page at any time.

Note: For simplicity, we use "table" in the following description to refer to any of database object in the project. A database object can be either a table, a view, a custom view or a report.

The Table Setup pages consists of two section. The upper section is a grid showing available options of all tables. The lower section contain two panels, the [Table-specfic Options] panel and the [Master/Detail] panel for the selected table.

Notes:

1. For all checkbox or combobox columns, if you want to apply the setting to ALL tables or views, you can choose your setting at the [Tables] or [Views] or [Custom Views] or [Reports] row.
2. View/Edit/Search functionality works at field level and can be setup for each field in the Field Level Setup page. Please refer to the Field Setup for details. If all fields are not selected for View/Edit/Search, the function will not be generated.
   

The available table level settings are as follows:

Generate
Select/unselect a particular table for generation

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

Add/Copy/Delete/Edit/Inline Edit/View
Enable/disable add/copy/delete/edit/Inline Edit/view function of a table. If a primary key exists, default is True except Inline Edit.

IMPORTANT:
ASP.NET Maker has assumed that all tables have a primary key. (Composite key is supported since v2.0) If there is no primary key specified, these settings have no effect and will be reset to False when the [Generate] button is pressed. Only the list page can be generated. If you add a primary key later, you'll need to come back to this page and re-enable them.

Notes: These settings are not applicable to reports.

Search
Four modes for searching is supported.

• [NONE] - No searching facility is generated
  
• [BASIC] - Quick search button will be generated with the list page
  
• [ADVANCED] - An Advanced Search Page will be generated and linked to the list page
  
• [BOTH] - Both Quick Search and Advanced Search will be generated

Note: Basic (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 by selecting [ADVANCED] or [NONE] .

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

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

Sort (ORDER BY clause)
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.

Default
Set a Table as the Default Table. The Default table is the first table the user see when visiting your site. Select the table you want in the [Default] column.

Menu Item
Uncheck the table in the [Menu Item] column if you don't want to show the table in the navigation menu generated by ASP.NET Maker.

You can also change the display order of the menu item by drag-and-drop. Select a table by clicking the first column - [Table/View Name] column, then drag and drop to where you want. Note that a table cannot be moved out of its parent node.

Audit Trail
ASP.NET Maker (3+) supports audit trail. If audit trail for a table is enabled, when an user add/copy/edit/delete a record, the related information will be logged in a log file. To use this feature, you must also specify the [Audit Trail folder] under [ASP.NET]->[General Options] tab. See ASP.NET Setup for details.

Email on Add/Delete/Edit
ASP.NET Maker (3+) supports sending notification emails. If this feature is enabled for a table is enabled, when an user add/copy/edit/delete a record, the related information will be emailed to specified recipient(s). To use this feature, you must also specify the [Email Settings] under [ASP.NET]->[Email Settings] tab. See ASP.NET Setup for details.

Table-specific Options
Same as the list page options as described in ASP.NET Settings except that the options are table-specific, meaning you can have different list page options for different tables. To use table-specific options, select a table in the grid, uncheck [Use global settings] in the [Table-specific Options] panel, the panel will be enabled for you to setup.

Master/Detail
When you set up a master/detail relationship, you link two tables so that all the records of one table (the detail table) always correspond to the single current record in the other table (the master table).

You can establish master/detail (one-to-many) relationship between two tables as follows

1. Select a table (the detail table) in the table grid,
2. Select the master table in the [Master Table] combobox,
3. Click [+] to add joined fields, select [Master Fields (Key fields)] and [Detail Field (Foreign key fields)]. Repeat until the relationship is setup.

If you want to clear the settings, press [Reset] button on the toolbar.

Detail fields specify the names of one or more fields (foreign keys) in the detail table (the current table) that are used to establish a Master-Detail relationship between this table and the master table. Master fields specify the names of one or more fields in the master table (specified in the [Master Table] combobox) that are used to establish a Master-Detail relationship between this table and the master table. In most cases, master and detail tables are joined by one field and you have one row in this table only.

Different tables can choose the same table as master table. In other words, a master table can have multiple detail tables.