User Manual

08.14.2024

MANUAL

FAQ: How to display items from parent and child tables on the list screen

## Answer Set it in the "「Table Management」" - "[List](/en/manual/table-management-grid)" tab. --- ## Overview Tables linked using the table link function can display items other than the title in each list view. Here, we will explain that Team Management (parent table) and Project Management (child table) are linked. ## Configuration ・Create two record tables, Team Management and Project Management. ・Link Project Management (child table) to Team Management (parent table). ![image](https://pleasanter.org/binaries/5edd7d5b92d44796a8b5893944c7f06f) The team name will be the title of Team Management. ![image](https://pleasanter.org/binaries/c93d9e10faec4649a1d2dfc52d124019) In Project Management, the title of Team Management (team name) is displayed as an option with the display name "Team in charge" as shown below. ![image](https://pleasanter.org/binaries/929cd12a1ffa4a3088b431132103172f) ## Usage Example Normally, in Project Management, only the title (team name) of the parent table, Team Management, is displayed ![image](https://pleasanter.org/binaries/d3c98cd7110644e2a1ce92b0a83906bd) Open Project Management, open the List tab from Table Management, and open the drop-down list at the top of the selection column to display the linked table. Select Team Management and enable Contact Person and Extension Number. ![image](https://pleasanter.org/binaries/e1c2387402414029a2dabc7e97b0a481) Click the refresh button to return to the list screen, and the Contact Person and Extension Number items in Team Management will be displayed. ![image](https://pleasanter.org/binaries/2068d873c55942b3b3b843ed867e6d99) Next, in the same way, open the parent table Team Management, select the child table Project Management in the List tab, and enable the title. ![image](https://pleasanter.org/binaries/5c6b1023936f4b44b8b2af377ca17b28) Team Management originally only had four records, but the display content will change by enabling the title of the child table Project Management. ![image](https://pleasanter.org/binaries/842d4b5e549f43dda20d6e771f9d0c39) Since the fields of the child records linked to each Check Management record are displayed, the original Team Management records will be displayed duplicated. ![image](https://pleasanter.org/binaries/ef5482567e2f4479a4508617c9d22bf5) If there are no linked records, "No Title" is displayed. ![image](https://pleasanter.org/binaries/ea0c4f06a79b41a48e0f852cb1283fe2) ## Notes When displaying child table items in the parent table list, the checkboxes to the left of each row are hidden to prevent unintentional deletion of records due to erroneous operations, so bulk update and bulk delete cannot be used. ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management-grid">Table Management: List Screen</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.