1. Module Name: Give a name to your module.
2. Select "Data Edit Form" module and click Create.
Data Edit Form allows you to edit existing data in the linked table.
There are two (2) types of Data Edit Forms:
Even though both are similar in many ways, they are slightly different in the way their SQL Query module are constructed to query the edit data.
Data Edit Form as a Standalone module - Standalone Form can be executed directly from the Main Menu. To accomplish this, it will require an SQL Query with a WHERE filter condition matching Static or Fixed values, or matching global variables such as LoggedIn user ID and/or user TimeStamp variable.
Data Edit Form as an Intrinsic module - require an SQL Query module with a WHERE filter condition and a POST/GET field variable option set. Intrinsic Forms are triggered as an action of a Data Select/Search Form (POST) or a click from a HTML Hyperlink (GET).
You will be presented with a default Data Entry Form. Most fields have default entries and selections, you may change those options to best suit your requirements. At the Data Source Table field, select from the list, the table you will link to the form, hence data in the selected table will be edited by this form. Click Save to save any changes
It is important to ensure the Primary Key field indicated by PK is mapped to either a Hidden or Text Box field to query the edit data, see example below. This is required in order for your Edit form to work correctly.
This should be your first field to add to your Data Edit From. See example below. See Adding and Editing Form Elements section to continue adding the rest of your form elements.
Click on + Custom Filter button to configure how the edit data will be selected. Typically, edit data is selected using FORM or Hyperlink submitted POST/GET variables such as the Primary Key (PK) variable and other fields. See link below how to configure other custom queries.
Example confuguration of FORM submitted POST/GET field variable using Primary Key (PK) field. To add multiple selection conditions, each query statement must be accompanied or joined by an AND/OR operator.