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 it works on example:
 

 

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:

 

 


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.

Share the discussion in the social networks: