Creating and Updating Master Detail Tables

Master Detail tables are those tables where you would like to keep information of a certain transaction. See example of Master Detail tables.

Prescient Author adds one default table (TableName_detail) when you create Master Detail table (TableName_basic).

One table (i. e. TableName_basic) is added to store information which is common for the transaction and another table (i. e. TableName_detail) is added to store detailed information of the transaction .

Following are the steps to create a Master-Detail Table.

Right click on Master-Detail Table option in Module Section of Project Tree. Select Create Table option. OR click on the Master Detail Tables button on the Prescient Author Navigator dialog box.
Master Detail Table Definition dialog box appears on the screen.
Specify table name in Table Name text box. The table name could be alphanumeric. It should not have any space in between. The table name cannot be started with a number.
You can add the fields in the table. (Refer to Adding and Updating Fields).
You may define any field from the table as Front Field of the table. This helps Prescient Author to intellegently show this field in the UI. You may select that field of the table as front field which best represents that table. Generally, name and description fields are best suited as front fields. For example, in case of a table Customer, you may wish to see Customer_Name as front field.
The dialog box shows Generate Forms and Reports check box. The check box is default ON. If you do not wish to generate the corresponding UI for your table, you can turn this check box off. Prescient Author generates forms and reports corresponding to this Master-Detail table. It also generates menus to access these forms and reports. You may modify these forms and reports later. (Refer to Create and Update Master-Detail Form ).
Click on Ok Button to create the table.
Prescient Author provide client side validations. On Master Forms Prescient Author uses Dot Net Validation controls like RequireFieldValidator, CustomValidator, Compare Validator for validation. On the Detail Part i..e. Grid of the form, Prescient Author Uses Java Script Validations.