# Display records with a three stage portal setup **URL:** \ **Category:** Questions\ **Created:** [March 3, 2021, 4:12pm UTC](https://the.fmsoup.org/t/display-records-with-a-three-stage-portal-setup/1804 "2021-03-03T16:12:56Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![MauriceD](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@MauriceD](https://the.fmsoup.org/u/MauriceD)\ **Post date:** [March 3, 2021, 4:12pm UTC](https://the.fmsoup.org/t/display-records-with-a-three-stage-portal-setup/1804/1 "2021-03-03T16:12:57Z")
Hello forum members, I’d like to ask for your help regarding the following. Currently I’m working on a multi-lingual catalogue in English, German, Dutch, French and Spanish. The articles in the catalogue all belong to a product subgroup which in its turn belongs to a product maingroup (please see picture). ![example tables](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/3/34f5e8c70cbf008713f63ce4c90df1b1ee6c857d.png) I set up a layout which shows records from the maingroup. On that layout is a portal showing records from the maingroup as a master. On the same layout is another portal containing records from the subgroups. Sofar a standard master-detail setup. Clicking on a line in the maingroup portal nicely yields the linked subgroups in the second portal. Now I added a third portal: a portal containing the articles. The way I want it to work is the following: clicking on a main group in its portal shows the linked subgroups in their own portal (nr.2), and clicking on a subgroup will show the linked articles in the articles portal (nr. 3). But now for my problem. The article portal now shows all articles belonging to all subgroups of one maingroup. Clicking on a subgroup should only yield the articles for that subgroup. I cannot get this to work. Please see my attached file. Thank you beforehand. Kind regards from Spain, Maurice [MPartscatalogue.fmp12](https://the.fmsoup.org/uploads/short-url/oOImq6fkA9kFxMTBc6JjzI4aOvW.fmp12) (516 KB) ---
**Author:** ![bdbd](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bdbd/32/620_2.png) [@bdbd](https://the.fmsoup.org/u/bdbd)\ **Post date:** [March 3, 2021, 4:39pm UTC](https://the.fmsoup.org/t/display-records-with-a-three-stage-portal-setup/1804/2 "2021-03-03T16:39:43Z")
You either filter the display of articles or make a direct relationship between maingroups and articles. In the case of the filter, selecting a subgroups sets a global variable or global field that is used by the filter. In the case of the relationship, selecting a subgroups sets a global field in the maingroups table. That global field is the left-side field in the maingroups - articles relationship. Hope this helps. ---
**Author:** ![harvest](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/harvest/32/231_2.png) [@harvest](https://the.fmsoup.org/u/harvest)\ **Post date:** [March 3, 2021, 4:56pm UTC](https://the.fmsoup.org/t/display-records-with-a-three-stage-portal-setup/1804/3 "2021-03-03T16:56:34Z")
just added global field and relationship to show all parts of the main group and scale down to only parts of the selected subgroup [MPartscatalogue\_variant.fmp12](https://the.fmsoup.org/uploads/short-url/7EwbAPFIlTmVFA3IKvajB5iYubc.fmp12) (516 KB) ---
**Author:** ![MauriceD](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@MauriceD](https://the.fmsoup.org/u/MauriceD)\ **Post date:** [March 4, 2021, 9:10am UTC](https://the.fmsoup.org/t/display-records-with-a-three-stage-portal-setup/1804/4 "2021-03-04T09:10:47Z")
Thank you. Greatly appreciated. ---
**Author:** ![MauriceD](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@MauriceD](https://the.fmsoup.org/u/MauriceD)\ **Post date:** [March 4, 2021, 9:11am UTC](https://the.fmsoup.org/t/display-records-with-a-three-stage-portal-setup/1804/5 "2021-03-04T09:11:00Z")
Thank you.