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