English Español Deutsch Italiano Polski Nederlands Português Français 中文 日本語 हिन्दी اللغة العربية Русский Українська עִברִית Ελληνικά Türk Latvietis
Log In
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)


Please, login to QuintaDB to be able to post comments

System Administrator

This is great! Wonderful update, make our use of DB much much easier, thanks!

Share the discussion in the social networks: