A subform is a form that is inserted in another form
When you are working with relational database, you often need to view multiple tables or fill out several tables using one form.
Subforms on QuintaDB service are a convenient tool for doing this.
In other words, the Sub-form is a form that is inserted in another form.
They are generally used when you need to show data from tables with a one-to-many relationship.
For example, let’s take the “Contracts” table, which contains all current contracts with the company.
The task is to relate customer with his contracts. In this case, one customer may have many contracts.
I’m creating a new form called "Сustomers". I have already created contact input fields.
Now I need to create a Subform field. You can find it in the "Advanced" section.
Select the “Сontracts” table from the drop-down list.
This is how Subform looks on the main form:
The "Customers" table:
On the Subform field editing page you can:
In the Subform settings tab you can:
For example, let's back to the "Customers" table. The task is to show the total amount of all contracts for a particular customer.
To do this, add the linked column field and select the "Amount $" column.
As a result, you get a "Total" column in which shows the total amount of all contracts: