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:
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.
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.
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.
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: