FAQ: Expressing a many-to-many relationship
## Answer
Please use one of the following functions.
1. Set "[Multiple Selection](/en/manual/table-management-multiple-selections)"
1. Create an intermediate table
---
## Overview
When using the "[Link](/en/manual/table-management-choices-text-link)" function, normally only one parent table can be selected from a child table, resulting in a 1 (parent): N (child) relationship. If you want to express a many-to-many relationship of N (parent): N (child), please follow the following settings.
## Method 1 Use Multiple Selection Of Links.
By setting "[Multiple Selection](/en/manual/table-management-multiple-selections)", you can select multiple parent tables from a child table.
## Method 2 Express A Many-to-Many Relationship Using An Intermediate Table.
Here is an example of using an intermediate table to link relationships in which multiple members are in charge of multiple projects.
![image](https://pleasanter.org/binaries/5becc82a856b4a2380359edcd50834b1)
## Configuration
・Create three recorded tables for members, projects in charge, and projects.
・Link the responsible project (child table) to the member (parent table) and project (parent table).
*The responsible project is the intermediate table.
![image](https://pleasanter.org/binaries/ab03bc76a9cc4c4d827b6743a8a18afb)
## Usage Example
In the responsible project, you can enter column from both the linked member and project tables.
![image](https://pleasanter.org/binaries/3ea3a5a73fb44dfb9a75064916bf9247)
You can link and register which member is in charge of which project and who is in charge of the target project.
![image](https://pleasanter.org/binaries/f3f412cb2fdf4576811e6851444799e9)
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-management-choices-text-link">Manage Table: Editor: Column Advanced Settings: Option List: Link</a><span>10.11.2024 up</span></li>
<li><a href="/en/manual/table-management-multiple-selections">Manage Table: Editor: Column Advanced Settings: Multiple Selection</a><span>10.02.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />