Relational fields are part of the custom objects limited release for select Enterprise customers.
What is a relational field?
A relational field links a record to other records. For example:- An LP with a Commitments field that links to its Commitment records
- A Portfolio Fund with a Portfolio Companies field that links to organizations
- An Event with an Attendees field that links to people
Before you start
An admin must first allow the two object types to relate to each other, from Settings > Manage Objects > Edit > Related Custom Objects. Only those objects appear when you create a relational field. See How to create and manage custom objects.Create a relational field
- Open a list or directory of custom object records.
- Click the + at the end of the column headers.
- Under New relational field, choose the object you want to link to.
- Choose a Relationship type, then click Next:
- Both ways adds a field on both objects, so the link shows on both sides.
- One way adds a field only on this object. Nothing shows on the other side.
- Configure the field on this object:
- Name: how the field is shown. The default is Related followed by the other object’s plural name.
- How many can be linked: Multiple or Single.
- Where this field appears (when you start from a list): Global, or List Specific to show it only on this list.
- Finish creating the field:
- For a One way field, click Create field.
- For a Both ways field, click Next, configure the matching field on the other object, then click Create field pairs.
- Click Save on the view to keep the new column.
Link records
- Click a relational field cell.
- Search for a record and choose it. For a Multiple field, repeat to add more.
- To remove a link, click the remove icon next to the record under Already selected.
Delete a relational field
Deleting a two-way relational field deletes the fields on both objects and every link stored in them. You’ll be asked to type the field name to confirm.Limits
- You can’t yet link people, organizations and opportunities to each other with relational fields.
- You can’t filter or sort by relational fields yet.
- Relational fields and their values don’t show in a record’s side panel or page yet. Use the directory or a list to see them.
- Lookup fields (showing a field from a linked record) and rollup fields aren’t available yet.