multiple parent/child portals

[stefangs]

i'm trying to put several portals on a layout that lets me quickly look up stuff like this:

portal 1 should display the main category (unfiltered, i.e. a list of things). clicking on a portal row should filter portal 2.

portal 2 should contain subcategories. clicking on a row should filter portal 3.

portal 3 should contain a list of items. clicking on a row should reveal a number of detail fields.

-

the way i have it set up now is with the table focus on main category. i get the list in portal 1 using a selfjoin. clicking on a row sets a global field to the ID of the main category and portal 2 now displays appliccable subcategories in portal 2.

the table for subcategories also contains a global which is set when clicking on a row in portal 2, similar to the way the above relationship works. however, the third portal remains empty.

perhaps it has to do with the table focus, because i am asking for a relationship that is one step further away than the normal parent-child relationship. is there a workaround to this scenario or am i missing something altogether?

[normanicus]

I am not sure from your description how the third portal relationship works but it appears that it may have a global field on both sides. This would not work as it could not be indexed.

Apologies if my understanding is wrong.

[stefangs]

actually. the relationships are set up differently. i just realized how difficult it is to explain and so i made a quick template.

when i did, it worked! so i must have something mixed up in my real file which i'm sure i'll find. i'm posting my template which may be useful for other users also.

Multiportals.fp7.zip