- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2021 07:41 PM
以下の2テーブルを結合し、1つのListLayout(テーブルビュー)として表示したい。
これまでに、テーブルAのテーブルにタイプ「参照」でテーブルBの項目を作成し、ListLayoutに見かけ上上記ListViewが表示できました。
ただ、テーブル間の結合条件(SQLでいうwhere テーブルA.項目1=テーブルB.項目1)のような条件を指定する方法が分からず困っています。
参考になるナレッジが見つからず、教えていただけますでしょうか。
<元になるテーブル>
---テーブルA--- ---テーブルB---
項目1 項目1
項目2 項目4
項目3 項目5
-------------------- ---------------------
↓
----------表示したいListLayout(テーブルビュー)--------------
項目1
項目2
項目3
項目4
項目5
ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2021 04:59 PM
Thank you for replying.
Based on your coment, I check my Setting again.
This problem is caused by missing of the relation of table.
so i make the relation of table through the use of flow desighner, and solve it.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2021 07:48 PM
If I understand correctly using google translate.
You need use the list layout to show the fields from table A and B then you setup a filter on the list doing dot walking between both tables using that field you have as a reference between both tables.
Set your List Layout, right click on the top of the list
Dot walking for the filter
Please mark as helpful/correct if this works for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-16-2021 04:59 PM
Thank you for replying.
Based on your coment, I check my Setting again.
This problem is caused by missing of the relation of table.
so i make the relation of table through the use of flow desighner, and solve it.