Multi Relation
Link this row to several records in another table.
Type
multirelationValue
Editable
Unique
No
Multi Relation stores links to several rows in another table. You pick the related records in the cell. A matching reverse column is created on the other table so the link is two-way.
Use Relation when the cell should point to only one row.
If the reverse column is Relation (one), a related record can appear in only one Multi Relation cell. Picking it on another row moves it off the previous row.
Name, key, hidden, and permissions are the same for every column — see Tables.
Configure
| Setting | Description |
|---|---|
| Target Table | Which table to pick from. Locked after create. |
| Display Field | Field on related rows shown on chips (for example product name). |
| Subtitle Field | Optional second line in the picker (for example SKU or price). |
| On Delete | When a linked row is deleted: Nullify, Restrict, or Cascade. |
| Reverse Name | Name of the column created on the other table. Create only. |
| Reverse Type | Relation or Multi Relation on the other side. Defaults to Multi Relation. Create only. |
Use case
- An order’s Products: pick Widget and Gadget.
- A customer’s Orders reverse of Orders → Customer, for Rollup such as order count or revenue.