Return

Link records from different tables

Create relationships between tables and use linked records in your interface and APIs.

Steps at a glance

1. Decide what you want to link (one-to-one, one-to-many, or many-to-many).
2. Create a relationship column between your tables.
3. Create records and link them together.
4. Retrieve linked records in your interface (or from an API).

1) Decide what you want to link

Before you add a relationship, clarify how the data should connect:

• One-to-one — One record links to one record (for example, User → Profile).
• One-to-many — One record links to many records (for example, Customer → Orders).
• Many-to-many — Many records link to many records (for example, Students ↔ Courses).

2) Create a relationship between two tables

Example: Customers and Orders (one customer can have many orders).

1. Open Data & API → Tables.
2. Open the table you want to edit (for example Orders).
3. Create a new column and choose a relationship type.
4. Select the other table you want to link to (for example Customers).
5. Name the relationship (for example Customer).
6. Save.

3) Create and link records

1. Create a Customer record.
2. Create an Order record.
3. In the Order record, set the Customer field to the customer you created.

Now each order is linked to a specific customer.

4) Use linked records in your interface

There are two common ways to use linked records:

Option A: Retrieve records with a view

1. Create a view for the table you want to show (for example Orders).
2. Add any filters you need (for example “Only show orders for the current user’s customer record”).
3. In your interface, retrieve the view and repeat items over the results.
4. Display fields from the linked record (for example show the order’s customer name).

Option B: Retrieve records from an API

Use an API when you need custom filtering, validation, or secure logic.

1. Create an API in Data & API → APIs (for example GET /orders).
2. Retrieve the records you need.
3. Return the records to the interface and repeat items over the response.

Common pitfalls

The relationship field is empty

• Make sure you actually set the relationship field when creating or updating the record.

You chose the wrong relationship type

• If one customer should link to many orders, use a one-to-many relationship (not one-to-one).

Records appear but the linked data is missing

• Check that the records are truly linked (open a record and confirm the relationship field has a value).
• If you are using a view, confirm the view includes the columns you need.

Related guides

Using table views

Use views to save filters and reuse the same dataset across your project.

Beginner6 min

Adding, editing, and deleting records in tables

Create records, update them, and delete them safely using your tables.

Beginner8 min