This field type allows you to show records from a related table
Using this field type, you can show all records from the linked table in a separate column.
Here is an example. We take two forms: "Units" and "Employees"
"Units" form:
In the "Employees" form there is a Relationship field, linked to "Units" table. Relationship type is many-to-one.
The task is to show all employees of unit in the "Units" table.
We have already completed both tables:
Please note: using Relationship field, we linked each employee to a specific unit.
Next, in the "Units" Form builder you need to add a new field - "Linked records":
Now in the "Units" table you can see all the employees:
The linked records are displayed as a column by default. On "Linked records" field editing page, you can change how to show data in table and specify which columns to display:
Read also: Subform (field type)