I've discussed this with two Gurus and unfortunately was given two answers neither of which I have been able to implement. This is what I'm trying to do: I have one file with two tables. I have a layout that uses the second table to house pages(records)which are displayed and edited in the first table. Ie, think of it as Word.

So to recap: on this layout you type in one portal, then go below to next portal to create a "NEW PAGE" of your "multiple page document."

This works great however,

Now I want to put a portal in a completely seperate file that shows how many letters exist for each "patient", "Company" whatever it is..but I need to see in each of the seperate portals all the contents(pages) of each portal related to the ONE record they are associated with. As of now I can only show the first portal row. Following? Basically a Portal within a Portal. I've been told, hopefully this doesn't taint the poll, to use an auto-calc field and use valuelistitems. Another one was to use a recursive calculation and getnthfunction to get the contents of each text field in all the portal rows. Please help.. This has been a dilema I've been racking my brain to figure out.

Thanks!

Both answers you got are correct. The Valuelistitems one will work in FM6/7/8, the GetNthRecord only in FM8.

Did you try either approach? What didn't work when you tried?

I guess my problem is I don't exactly how to setup the calculation for this to work... either way. I've never used either of the functions.

have a look on the various FM sites (databasepros.com?) to see if they have any examples.