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
Comment this post