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.

Creating a Tabpanel