User Manual

08.14.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-record-import-and-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/034c03553d3d45d7a1a7417034f569d2) ## Configuration ・Create three record 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 items 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/4ed310029b724638aa39c392778ab40a) ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-record-import-and-link">Table Function: Import Records and Link Master Data</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-multiple-selections">Table Management: Editor: Item Detail Settings: Multiple Selection</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.