Feature Tour
Many-to-Many Fields

If you have an existing many-to-many relationship in your database, you can turn it into a virtual many-to-many field.

Employees, Territories, and EmployeeTerritories many-to-many relationship

When you edit the record, you will see a check box list of all territories. Those linked to the employee are checked.

When you edit the record, you will see a check box list of all territories. Those linked to the employee are checked.

The field will display a comma-separated list of territories linked to the employee when presented in read mode.

The field will display a comma-separated list of territories linked to the employee when presented in 'read' mode.

Learn how to configure a virtual field based on an existing many-to-many relationship.