Select Field with Editing Records

In this example, we will see how to create a link between the forms for the maintenance of the tables used in the selection fields (combobox).

You will create two forms

  • Product registration, in this register there is a field (select) to select categories.
  • Category registration, auxiliary application (pop-up window) for table maintenance categories.

Creating the Categories form

Note
If you have any questions on how to create a Form, go to: 
Creating a new Form

1. Create a new “Single Record” Form based on the Categories table.

2. Still in the application creation window, if you want a better display of the Form, select the “Fields” tab and change the Label of the fields, as shown below:

3. In the application menu, open the Fields folder and click on the categoryid field.

4. In the Field settings, navigate to the “Value in the Database” tab , and change the value from “Insert” to “Auto Increment”.

5. In the ScriptCase toolbar, click the Generate Source button.

Creating the product form

Note
If you have any questions on how to create a Form, go to: 
Creating a new Form

1. Create a new “Single Record” Form based on the Products table .

2. Still in the application creation window, if you want a better display of the Form, select the “Fields” tab and change the Label of the fields, as shown below:

3. In the application menu, access the Fields tab and select the CategoryID Field .

4. In the Field settings, navigate to the “Edit Lookup” tab , and replace the code in the text box with the code below:

SELECT categoryid, categoryname FROM categories ORDER BY categoryid

Creating a link between the Forms.

Note


If you have any doubts on how to create a Link between Applications go to: Creating Links between Applications.


1. Still in the “Edit Lookup” tab , click on the “Create Link” button.

2. Once this is done, select the Categories Form created previously and click on proceed to create the Link between Forms .

3. Finally, after creating the Application Link, select the “Run Application” button

Tutorials in the same category

Responsive login form 3

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form 2

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form

To learn how to use the templates available within the ScriptCase in the security module, follo...

Form with Fixed Label

This option can be selected in the forms of type the Multiple Record, Editable Grid and View. ...

Comment this post