Nested Portals

[DougAllen]

Is it possible in Fmkr 8 to nest portals? That is, put a portal inside another portal?

Table A is linked to Table B; Table B to Table C. I'd like to put a portal on a Table A layout showing related Table B records. In that portal I need a second portal showing Table C records related to the Table B records in the outer portal. When I try this the inner portal shows up in only the first record of the outer portal, and shows all the related Table C records indirectly related to the Table A record.

[SteveB]

Nope. One way of doing what you wnat would be to create calculations in Table B that pull the data from Table C.

Steve

[Fenton]

Since you say FileMaker 8 Advanced, you might want to look at the Custom Functions GetNthRow and GetRows (they work together; by Bruce Robertson). GetRows can calculate text which looks much like a portal, as a single field; which you can then display in your "parent portal" (contradictory terms).

http://www.briandunning.com/filemaker-custom-functions/list.php

It's not a true "portal within a portal" however, it just looks kind of like it. You can't click on one of its lines and expect it to know which one (unless you put invisible buttons over them, to run a script, with incrementing parameters). You certainly can't enter data in them, they're a calculation field.