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 Data Grid control with buttons which are having predefined actions like New, Save, Delete, Search, Export, and Close.
[Give hyperlink to above mentions buttons]
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.
To create Table-Detail Entry Form
Click New Form button.
Select Form type as Table-Detail Entry.
Select Table Name from the drop-down (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 integer data type.
CheckExclude table name in field names generated in new forms [Link] to exclude Table Name.
Click on Create button.
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).
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 Manipulating, Deleting the Selected Record, Exporting Data to Excel and other Validations / Checks on the Controls (which are manually added).