Placing Forms within a Form

Forms may be placed within other forms by placing a tabpanel on a form. A tabpanel can show other forms with the solution (including forms from other modules).

Placing a Form within a Form

Before we can place a related form on another form, we must create a Relation.  A relation is a link between to tables (or a global variable and a table)

Creating a Relation

For this example, we will create a relation in the example_data database from customers to orders.

To create a relation:

1. Do one of the following
2. Select the table for the left side of the relation by clicking on the ... button. For this example, select example_data.customers
3. Select the table for the right side of the relation by clicking on the ... button. For this example, select example_data.customers.
4. Select the primary key of the parent(left) table and the matching foreign key of the child(right) table.  For this example, ensure the customer_id equals the customer_id.

   NOTE

   Servoy Developer will normally try to match these ids if they have the same name and it is a true primary key to foreign key match.

5. Set the constraints for the relationship. For this example, leave them as they are by default.
6. Save the relation editor. See Intro to Servoy Developer environment

Creating a Tabpanel