User Manual

10.11.2024

MANUAL

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="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.