## Overview You can set parent-child relationships for "[Class Column](/en/manual/table-management-class)" in the "[Editor](/en/manual/table-management-editor)". When a parent class column is selected, the child class column options automatically switch to those corresponding to the selected value of the parent column. ## Notes 1. There is no limit to the number of columns or hierarchies that can be linked, but if you use them too much, performance may deteriorate when you open the edit screen. ## Limitations 1. If you perform "[Import](/en/manual/table-record-import)" on a "[Table](/en/manual/table)" that has "「Relating Column」" set, the parent-child relationship may not be registered correctly. If there are duplicate name displayed in [import](/en/manual/table-record-import), the first data found will be linked regardless of the "「Relating Column」" settings. If there are duplicate name displayed in the child "[Column](/en/manual/table-management-column)" of "「Relating Column」", the value of the parent "[Column](/en/manual/table-management-column)" may be set to the value of the unrelated child "[Column](/en/manual/table-management-column)". If the value of the parent "[Column](/en/manual/table-management-column)" and the value of the unrelated child "[Column](/en/manual/table-management-column)" is set, the value of the child "[Column](/en/manual/table-management-column)" will be cleared and left blank when you open the "[Editor](/en/manual/table-management-editor)". 1. Does not work with Read-only Columns. 1. Does not work with "[List Edit](/en/manual/table-record-editongrid)". ## Prerequisites 1. "Site Administration Permission" is required to configure settings. 1. The columns to be linked must be in a parent-child relationship based on their order of appearance. The selection list of class column in a parent-child relationship must specify the site set by the "[Link](/en/manual/table-record-import-and-link)". 1. Only class column displayed in the editor screen can be linked. ## Operation Procedure 1. Create Tables and Master Data First, create the following three recorded tables. The Address Book table links to the Prefecture Master and City Master tables. The City Master table links to the Prefecture Master table.  ## "Prefecture Master" Table  The "Prefecture" is the title column. ・Create two records with prefectures "Tokyo" and "Kanagawa". ## "City Master" Table  The "City" is the title field. Create the following six records, selecting the appropriate prefecture in the "Prefecture" column. |Prefecture|City| |:---|:---| |Tokyo|Nakano Ward| |Tokyo|Shinjuku Ward| |Tokyo|Shibuya Ward| |Kanagawa|Yokohama City| |Kanagawa|Kamakura City| |Kanagawa|Kawasaki City| Link the "City Master" table with the "Prefecture Master" table. Select "Prefecture" for "Link Column". Create new records, select either "Tokyo" or "Kanagawa" in the "Prefecture" column, and then input the corresponding city or town in the "City" column. ## 2. Set Up Links  　・Link the "Address Book" table with the "Prefecture Master" table. For "Link Column", select "Prefecture". 　・Link the "Address Book" table with the "City Master" table. For "Link Column", select "City". ## 3. Set Up Column Linkage Open "[Manage Table](/en/manual/table-management)" for the "Address Book" table, and click "Create New" under "Column Linkage Settings" from the "[Editor](/en/manual/table-management-editor)" tab.  The columns that have been linked will be displayed in the option list, so "Enable" "Prefecture" and "City". At this time, the columns at the top will be the major classification, and will be the columns that will narrow down the child columns, so "Prefecture" must be set above "City".  This completes the setting up of column linkage. When you select the "Prefecture Master" column in the "Address Book" table, only the narrowed down data will be displayed in the "City Master" according to the selection.   ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table">Table Function</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-editongrid">Table Function: Edit A List Of Records</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-import">Table Function: Import Record</a><span>02.06.2025 up</span></li> <li><a href="/en/manual/table-record-import-and-link">Table Function: Import Records and Link Master Data</a><span>02.06.2025 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management">Manage Table</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-column">Manage Table: Column</a><span>10.07.2024 up</span></li> <li><a href="/en/manual/table-management-class">Table Management: Item: Classification</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-editor">Table Management: Editor</a><span>08.13.2024 up</span></li> <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></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />