> For the complete documentation index, see [llms.txt](https://docs.ninox.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ninox.com/builder-hub/design-your-app/add-and-edit-data-fields-in-your-tables/all-data-fields/link-many-records-reverse.md).

# Link many records (Reverse)

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](/builder-hub/design-your-app/add-and-edit-data-fields-in-your-tables/all-data-fields/shared-field-settings.md).

Field-specific settings for **Link many records** are:

<i class="fa-airplay">:airplay:</i> **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

<img src="/files/amKA5qyaK2bcB1SHywyG" alt="" data-size="line">**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
* **Show add record row**: shows a row at the bottom of the table that adds a new record when clicked
* **Multi-select and bulk actions**: lets users select multiple records and perform bulk actions
* **Inline editing**: lets users edit records directly in the table

{% hint style="info" %}
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.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.ninox.com/builder-hub/design-your-app/add-and-edit-data-fields-in-your-tables/all-data-fields/link-many-records-reverse.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
