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.