English Español Deutsch Italiano Polski Nederlands Português Français 中文 日本語 हिन्दी اللغة العربية Русский Українська עִברִית Ελληνικά Türk Latvietis Dansk Norsk Íslenska 한국어 Suomen Gaeilge Bahasa Melayu Svenska Čeština
Log In

Log In


How to create relationships between database forms online

Database relationships allows you to link your tables (web-forms). You can set one to one, one to many or many to many relationships using our simple and easy to use interface

A relational database is important for business process. It is a database based on the relational model of data and provides access to records that are related from one table to another.

In order to link tables in QuintaDB you have to add Relationship field in Form Builder and configure it.

In this video you'll see how to create a lookup table :


In order to link forms in QuintaDB you have to:


- go to Form builder menu

- create new field with Relationship type, select table or report with which to link current form and relaitonship type. Also display field type.

Relationship type can be:

- One-to-One

A one-to-one relationship used when one row from table A corresponds to one row from table B, and one row of table B corresponds to one row of table A.

It can be used for security purposes, to divide a large table, and various other specific purposes.

- Many-to-One

Using this type, a row in table A can have many matching rows in table B, but a row in table B can have only one matching row in table A.

- Many-to-Many

In this relationship, a row in table A can have many matching rows in table B.


Display type can be:

- Dropdown, Radio buttons

Multi Select with autocompletion, Checkbox

In QuintaDB you can have only one relationship between two forms.


Linked Column

In order to show several column's data from linked table you can create Linked column type field and select this field in 'Select display field'.

You can make the linked column field visible in the form.

Open the field editing page and mark following checkbox:

Read how to link imported records by this link.

Please, login to QuintaDB to be able to post comments

Jay Duque

How to link project to another project? Thanks

Igor Petrushenko

Hi, Jay!

It’s not possible. However, there is some options available in the Formula field, which will allow you to fetch information based on form fields. But we do not recommend it.
Instead think about why you have to do it. Maybe you just need to place all the forms within one project.


In this page the traslation to italian language don’t work.

Igor Petrushenko

Hi, torkandaniel!

Thank you for letting us know. We’ve not translated it yet.
We’ll do it as soon as only possible.


Hello, Is the relationship function limited in the free version? After a single relationship I get a message saying I have to upgrade but I dont see a relationship limit anywhere on the pricing tables.

Igor Nosovskiy

Hi jwsbfd3,
Yes, there is a limit of one “Advanced” field per application on the Free plan.

Share the discussion in the social networks: