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:

Subform settings

On the Subform field editing page you can:

• Set the minimum entries number.
• Set the default entries number (the number of open subform entries when the main form loading).
• A limit on the maximum entries number.
• Choose the subform's data order in the table and the data sorting method.

In the Subform settings tab you can:

• Choose how to show subform's data in table: as a column or a table.
• Show or hide some subform fields on the main form.
• Select option delete or not all dependent records in subform, when main form's record deleted.
• Show or hide the "Add new" link and change the text of this link.
• Show or hide "Delete" icon.

Formula and Linked Column

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.