Relation

Allow connecting this column with another column of another table, including the cardinality.

The relation will be shown with a line on the diagram.

Cardinality

Specify from the drop down the current cardinality of the relationship with the other field: 1-1 or 1-n or n-1 or n-n.

Check this to specify the target of the relationship. If uncheck, there will be no relation (default).

Select the table of the field (column) of the relationship.

Select the field (column) in the selected table (above).

Specify from the drop down the target cardinality of the relationship with the current field: 1-1 or 1-n or n-1 or n-n.