Kushal Tutorials - Document

Desktop App Builder Kushal| Table-Detail-Entry Form
Table-Detail Entry:

You need to select this type of form when you wish to design a form for editing table values with controls representing each table field.

Table-Detail Entry form helps you to perform data manipulation on the selected table along with its associated controls. This form will represent all fields of the selected table with different types of controls. Depending on the field's data-type in the database, the data is displayed over the Data Grid control with buttons which are having predefined actions like New, Save, Delete, Search, Export, and Close.

Note: Kushal expects users to follow database design guidelines for making applications work. For example, the primary key should mandatorily be set for each table in the database.

Create Table-Detail Entry Form

In the toolbar, click Forms, and then Click the New Form button.

In the window that opens, select Form type as Table-Detail Entry.

Select Table Name from the drop-down (The Dropdown lists all table names from the specified database)

Select the Primary Key Field.

Kushal automatically identifies the Primary key field from the table as defined in the database and it sets the primary key. In Kushal Primary key gets auto-incremented if it is of the integer data type.

Kushal automatically identifies the Sort field from the table as defined in the database and it sets the primary key. Sort Field can be selected from the Dropdown as shown below.

Check Use Title-Case [Link] to display the Table name in Title case.

CheckExclude table name in field names generated in new forms [Link] to exclude Table Name.

Click on Create button.

Note: If you have the composite primary key in your table, then you can change which primary key has to get incremented.

When an additional primary key is present in the table, that Primary Key field will be considered as a master field for auto-incrementing primary key field and set in the drop-down control by default (associate this control with a SQL to load the list in the Dropdown).

The Control Type Selection window opens, where you can select the type of control for the fields.

This form will help you to choose among the four types of Controls. The Datatype column can be changed only if it is either integer or string type.

The primary key fields will not be shown in the Control Type Selection form.

After selecting the appropriate control type for each field, click Ok button.

Kushal automatically creates the User interface for the selected Table. Further, you can modify the controls as per your requirements.

In Table-Detail Entry Form, Kushal takes care of Input Validation, Auto-Incrementing of Primary Key, Data Manipulation, Deleting the Selected Record, Exporting Data to Excel and other Validations and Checks on the Controls which are manually added.