Update Related Table (N:N)

In this example, we will create an application with update tables with many or many relationships using the Double Select object.

Creating a Form

1. Create a new application form based on the employee table.

2. On the application menu, click Field Positioning and delete all fields except employeeid, lastname, firstname, title and titleofcourtesy.

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

4. On the Edit tab of the Database Value, change the Insert property to Automatic (automatic) increment.

Creating a many-to-many relationship

5. On the application menu, go to the NN Relationships folder and click on the New Relationship item.

6. In the Field property, report territories, for Data type, select Integer and Label inform Territories. To continue, click on the Next button.

7. Click Choose Table and choose the table of territories, and then click the Next button.

8. Check the generated SQL command, if necessary you can modify it. To continue, click on the Next button.

9. In the Object property, select the Double Select option and the Height property, enter 15.

10. Selecting the relationship table. In the Name property of the table, the option Operadeeterritories.

11. Matching the employee fields and employee tables. For the employeeid field select employeeid.

12. This step will be related to the foreign key field. Select the territory field and click Next.

13. See settings. Change the Vertical alignment property to Start and click the Next button.

Tutorials in the same category

Login Form

1- You must create a new application of Control type and configure it as shown in the image below. ...

Contact Form

In this tutorial we will be preparing an application of the Control Form type in which the format w...

Registration Form

Lets' create a registration form. we can follow the steps below: 1- A new control type applicati...

Fields Digital Signature, Select2, Switch and Slider

This example shows the form fields added in Scriptcase version 9.2: Digital Signature, Classificati...

Comment this post