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

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.