Filter: Relating Column

Overview¶

You can set parent-child relationships between the "Class Column" in the "Filter" of the "Screen Index". If the "Filter" ClassA is prefectures and the "Filter" ClassB is city, ward, town, and village, when you select Tokyo in the "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" cannot be turned on at the same time.

Prerequisites¶

1. "Site Administration Permission" is required to configure.
2. This setting assumes that "Relating Column" for "Class Column" has been completed, and is a setting to apply "Relating Column" to "Column" on "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" 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¶

• Manage Table: Items: Class
• Manage Table: Filter
• Table Function: Record Screen Index
• Manage Table: Filter: Use Filter On Grid Header
• Manage Table: Editor: Relating Column