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:
If there you have a Subform in your table, then you can use their columns as operands for the Formula and also show the Linked column.
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:
ian@betoli.com
Can you have a main form with a subform shown as a table?
Igor Petrushenko
Hi, Ian!
Of course, as you can see on several screenshots in this post. Also please watch a video, you can easily change the view in subform settings.
vwsurf03@yahoo.com
" I have already created contact input fields "
Where are the CONTACT INPUT FIELDS
Igor Nosovskiy
Hi vwsurf03,
They were added in the “Customers” form builder. The creating process is left behind the scenes, because these are standard fields.
vwsurf03@yahoo.com
Another words, the Sub-form is a form that is inserted in another form
Shouldn’t it be " IN OTHER WORDS"? I am having a problem following the dialect but I have to go on because the product has potential
Igor Nosovskiy
We’ve already corrected the text. Thanks!
vwsurf03@yahoo.com
In my trial and error effort I seem to have created MULTIPLE SUBFORMS: Is there a way to remove them from the main form? Thanks
Igor Nosovskiy
You can remove them in the Form Builder menu.