Relations

A relation field links a record to one or more records in another collection — the same idea as a linked record in Airtable or a relation property in Notion.

Linking mode

A relation is configured as either:

• Single — each record links to at most one record in the target collection.
• Multiple — each record can link to several records in the target collection.

Display field

Pick which field on the target collection is shown as the label when you're browsing or searching for a record to link — usually the target collection's primary field, but it doesn't have to be. The relation editor searches across the target collection's records as you type.

Two-way relations

By default, a relation only shows up on the collection where you created it. Turning on two-way mirrors it onto the target collection too, so both sides can be browsed and edited:

• Turning it on creates a matching relation field on the target collection automatically. That mirror field is always multiple — since many records on this side could point at the same target record.
• Values stay in sync in both directions: linking a record on one side immediately shows the link on the other.
• Turning two-way back off hides the mirror field rather than deleting it — its data is preserved, and turning two-way on again brings it back with the data intact.
• Self-referencing relations (a collection linked to itself) don't support two-way yet.

Once a relation exists, you can pull data through it without duplicating it — see Computed fields for lookup and rollup fields.