Link Column

The Link column creates a relationship between two tables. Click a cell to search and select records from the linked table.

Relationship types

Type	Description	Example
One-to-One	Each record links to exactly one record in the other table	Employee → Laptop
One-to-Many	One record links to many records	Company → Employees
Many-to-One	Many records link to one record	Employees → Department
Many-to-Many	Records on both sides can link to multiple	Students ↔ Courses

Setting up

Add a new column → select Link
Choose the target table from the dropdown
Select the relationship type
The column appears; click any cell to search and link records

How linking works

Click a Link cell
A search popup appears showing records from the linked table
Type to search by any field
Click a record to link it
The linked record's primary field value displays in the cell

Using with Lookup and Rollup

Link columns are the foundation for Lookup and Rollup:

Lookup: Pull a specific field from the linked record into this table
Rollup: Aggregate values across all linked records (SUM, COUNT, AVG)

Example: CRM structure

Companies table
  ↓ (One-to-Many)
Contacts table (Link to Company)
  ↓ (One-to-Many)  
Deals table (Link to Contact)

On the Companies table:

Lookup: "Primary Contact Name" (from Contacts)
Rollup: "Total Deal Value" (SUM of Deals.amount)
Rollup: "Number of Contacts" (COUNT of Contacts)

Tip

Plan your table relationships before building. Draw the connections on paper first: which tables link to which, and in what direction. Changing relationship types after data is entered can be disruptive.

Note

When you create a Link column in Table A pointing to Table B, a reciprocal Link column is automatically created in Table B pointing back to Table A.