Link one record (Reference)

Connect one record to one record in another table.

Use a Link one record field when a record should reference one record from another table.

When you add a Link one record field, Ninox opens a dialog and asks which table you want to link. You can also link the same table to itself.

After you choose the table, Ninox creates the relationship field for records from that table. At the same time, Ninox creates the reverse connection in the other table and adds a Link many records field there.

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

Field-specific settings for Link one record are:

Display

• Display as: controls how users select the linked record

  • Popup: opens a table where users can search for a record to link to or create a new one
  • Combobox: shows a searchable drop-down list
  • Switch: shows the available records as horizontally arranged options
  • Radio buttons: shows the available records as a radio-button list
• Hidden columns: controls which columns appear in the selection view and how the linked record is displayed
• Filter: limits which records users can select

Behavior

• Composition: creates a parent-child relationship If it is enabled, deleting the parent record also deletes its child records. Use this option with caution.

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

• Show add record button: shows a button in the Popup view to create and link a new record
• Quick add at the bottom: shows an empty row at the bottom of the Popup view for quick record creation

If the field is displayed as Popup, users can click Select a record. Ninox then opens a table where they can search for a record or create a new one to link.

There, users can:

• select one record from the list and click Confirm to link it
• click + Add record to create a new record, if that option is enabled in Behavior

After confirmation, the selected record appears in the field.

Click the selected record in the field to open the linked record in a separate form view.

Use Link one record when the relationship should point to one record in another table. If one record should connect to several records, use Link many records instead.