Link many records (Reverse)

Connect one record to several records from another table.

Use a Link many records field when one record should connect to several records from another table.

When you add a Link many records field, Ninox opens a dialog and asks which table you want to link.

In that dialog, you can:

• search for a table
• select the table you want to link, including the current table itself

After you choose the table, Ninox creates the relationship field and shows the linked records in the form. At the same time, Ninox creates the reverse connection in the other table and adds a Link one record field there.

For the general settings all data fields have in common, see Shared field settings.

Field-specific settings for Link many records are:

Display

• Display as: controls how the linked records appear in the form

  • Table: shows linked records in an embedded table
  • Checkbox: shows available linked records as a checkbox list
  • Field: shows linked records directly in the form field and provides actions to link or unlink them
• Hidden columns: controls which linked-record fields Ninox shows
• Filter: limits which records users can see and link. You can add more than one filter.
• Group: groups the records by one displayed field

Behavior

The following settings apply only when Display as is set to Table:

• Show search field: shows a search field at the top of the relationship table
• Show add record button: shows a button that lets users add new records
• Link existing record: shows a button for linking an existing record instead of creating a duplicate
• Quick add at the bottom: shows a blank row at the bottom of the table for quick entry
• Multi-select and bulk actions: lets users select multiple records and perform bulk actions
• Inline editing: lets users edit records directly in the table

If you need a many-to-many relationship, use a third table that connects the two other tables with one Link one record field for each table.