One-to-Many Relations

This type of relationship presupposes connection of a record stored in the Master table with many records of the Detail table. For example, you manage an advertising agency and keep track projects and clients in TeamDesk database. Each client can order many projects, while every project can be ordered by only one client. As a result, each record of the Client master table can be related to many records of the Project detail table.

One-to-Many.png

The relation of the one-to-many type is set between a key column in the master table (using a key column ensures the uniqueness of a record to be related) and a single-reference column of matching type in the detail table.

Graphical user interface, table  Description automatically generated

Please note that One-to-Many relation is realized at the level of columns: a column in a master table is related with a column of matching type in a detail table.

Here you may see the example of the relation settings:

Graphical user interface, application  Description automatically generated

If you want to choose a reference column manually, please notice that the type of the Reference column should match the type of the Key column. So, you can match the same column types. Moreover, the following types can be matched with each other: Text type, AutoNumber, Phone, E-mail Address, Barcode.