This guide will show you how to setup and define relations between tables in a Vorted DBI.
In the Vortex there are three types of relations between tables.
For the first two relation types, 1-1 and 1-x, the record on the 1-side contains a field pointing to the related record, where the record on the x-side doesn't have this field but instead has a list of related records.
To create a relation field, simply create a field in the table of type Relation and give it a suiting name and description.
When the required tables and fields are created, open the Admin menu and choose Relations. An in detail description of relations is given in the User Manual
Observe that it is very important that the right field for the right table is chosen in the Field columns, otherwise behaviour of theese tables will be erratic!
Saving the relation makes the connection between the tables active.