In order to link tables in QuintaDB you have to add Relationship field in Fields menu and configure it.
In order to link forms in QuintaDB you have to:
- go to Fields menu
- create new field with Relationship type, select form with which to link current form and relaitonship type. Also display field type.
Relationship type can be:
Display type can be:
- Multi Select with autocompletion
Please, click here to watch screencast (without sound), where you can see how to link Team and Player forms.
In order to show several column's data from linked table you can create Formula field and select this field in 'Select display field'.
In QuintaDB you can have only one relationship between two forms.