Manage Table: Filter: Relating Column
## Overview
You can set parent-child relationships between the "[Class Column](/en/manual/table-management-class)" in the "[Filter](/en/manual/table-management-filter)" of the "[Screen Index](/en/manual/table-grid)". If the "[Filter](/en/manual/table-management-filter)" ClassA is prefectures and the "[Filter](/en/manual/table-management-filter)" ClassB is city, ward, town, and village, when you select Tokyo in the "[Filter](/en/manual/table-management-filter)" ClassA, it is possible to display only city, ward, town, and village in Tokyo in ClassB.
##### Sample Data
```
- Tokyo
- Suginami Ward
- Shibuya Ward
- Minato Ward
- Chuo Ward
- Chiyoda Ward
- Shinjuku Ward
- Nakano Ward
- Kanagawa
- Atsugi City
- Sagamihara City
- Zushi City
- Kamakura City
- Yokosuka City
- Kawasaki City
- Yokohama City
```
## Limitations
1. "[Use Filter On Grid Header](/en/manual/table-management-filter-use-grid-header-filters)" cannot be turned on at the same time.
## Prerequisites
1. "Site Administration Permission" is required to configure.
1. This setting assumes that "[Relating Column](/en/manual/table-management-column-relations)" for "[Class Column](/en/manual/table-management-class)" has been completed, and is a setting to apply "[Relating Column](/en/manual/table-management-column-relations)" to "[Column](/en/manual/table-management-column)" on "[Filter](/en/manual/table-management-filter)".
## Operation Procedure
1. Select Manage Table and click the Filter tab.
2. Select "Use Relating Columns" at the bottom of the screen.
("Use Relating Columns" and "[Use Filter On Grid Header](/en/manual/table-management-filter-use-grid-header-filters)" cannot be enabled at the same time.)
3. Press the "Update" button at the bottom of the screen to return to the Screen Index.
4. When you select "Prefecture" on the filter, confirm that only the data narrowed down according to the selection is displayed in "City/Ward/Town/Village".
## Related Information
<div id="ManualList"><ul><li><a href="/en/manual/table-grid">Table Function: Record Screen Index</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-column-relations">Manage Table: Editor: Relating Column</a><span>10.11.2024 up</span></li></ul></article>
<ul><li><a href="/en/manual/table-management-filter">Manage Table: Filter</a><span>10.02.2024 up</span></li>
<li><a href="/en/manual/table-management-filter-use-grid-header-filters">Manage Table: Filter: Use Filter On Grid Header</a><span>10.02.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
