English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Ελληνικά Flag Ελληνικά Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska Čeština Flag Čeština
User IconLog In
English Flag English

Log In

 

Linked records (field type)

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)