Skip to main content

Link records across tables and solutions

Link records from Grid View or a record with the record selector, unlink them, and see their details through the link.

Written by Emma Montgomery

Linking a record connects it to records in another table, so you can open one from the other and pull their details through. You link records in a Linked Record field, from Grid View or from an open record.

Here is the test: is the thing you are about to type already a record somewhere, such as a vendor or a contract? If yes, link to it instead of typing it.

Example: a Vendors table in a vendor risk program has a Contracts field that links to the procurement team's Contracts table. When a new contract is signed, the analyst links it to the vendor in two clicks. The vendor's record then shows the contract, and the contract shows its vendor.

The record selector open from a Grid View cell, with the search box, Add New Record, the gear and two contracts checked.

The record selector open from a Grid View cell, with the search box, Add New Record, the gear and two contracts checked.

Plan Availability

All plan types.

Permissions

Anyone who can edit the record can link and unlink records. Opening a linked record needs at least Viewer access to the linked table. Creating a record from the selector needs Assignee or higher in the linked table.

Platform

Web

Related Reading


Before you start

The table needs a Linked Record field that points at the other table. If it does not have one, an Administrator or Solution Manager adds it. See Connect tables within and across solutions.


Linking records from Grid View

  1. Select the cell in the Linked Record column and press Enter, or select the + in the cell.

  2. The record selector opens. Type in Find an existing record to search.

  3. Check the records to link.

  4. Select Link Records. With two checked, the button reads Link 2 Records.

The cell shows the first linked record as a pill, with a ... for the rest.


Linking records from an open record

  1. Hover over the Linked Record field and select + Add Record.

  2. Search, check the records and select Link Records.

Each linked record shows as a card with its title. Select the title to open the linked record.

Tip: If the record you need does not exist yet, select + Add New Record in the selector. You create it and link it in one step.


The record selector

The selector is where you find the records to link. From top to bottom:

  • Find an existing record: the search box.

  • + Add New Record: creates a record in the linked table and links it.

  • The gear (Record Selector Settings): choose which fields the selector shows, and sort, filter and group the list. For contracts, show the renewal date and sort by it. The gear is a builder setting that Solution Managers configure, and its filter applies to everyone who links from this field. Use it to keep retired records out of the list, such as inactive controls, so nobody links a risk to one.

  • The expand button: makes the selector bigger.

  • The list: one row per record, with a checkbox.

  • Cancel and Link Records.

If the field has preset filters, the selector shows them as tabs or dropdowns. The field's Advanced Settings set them. See Linked Record Field.


Unlinking a record

Hover over the linked record's card and select the x. The link is removed from both sides. The record itself stays in its table.

Note: If the field uses Enable the Sub-items mode, the icon is a trash can, and the record is deleted, not only unlinked.


Seeing linked data in the record

Linked records bring their details with them.

  • Open a linked record. Select its title on the card. You can read it without leaving the record you are in.

  • Show a value from it. A Lookup field shows a field from the linked record, such as each contract's renewal date on the vendor. When the contract changes, the lookup updates.

  • Count or total. A Count field counts linked contracts. A Rollup field totals their Annual Contract Value.


Linking across solutions

A Linked Record field can point at a table in another solution, so you link records the same way. The Contracts table can live in the procurement solution while the analyst works in Vendor Risk Management.

Access follows the linked table:

  • To open a linked contract, a member needs at least Viewer access to the Contracts table.

  • Without access, the member sees the contract titles but cannot open them.

  • To create a contract from the selector, a member needs Assignee or higher in the Contracts table.


Frequently asked questions

How many records can one cell link to?

There is no limit on linked records in one cell, unless the field allows one record only.

Why can I not open a linked record?

You do not have Viewer access to the linked table. Ask the solution's manager.

Why is + Add New Record missing?

Creating records from the selector needs Assignee or higher in the linked table.

Does unlinking delete the record?

No, unless the field uses Enable the Sub-items mode.

How do I count the linked records?

Add a Count field and point it at the Linked Record field.

Last verified 4 Nov 2026.

Did this answer your question?