Display found set in portal FMP7?

[hlabonte]

Anyone know of a way to display the current found set of records in a portal?

For example, my layout looks at the table "students". When I search for students in grade 8, i get a found set of say 10 records. I'd love to also show that found set in a portal, on the SAME layout. I'm developing this solution for the web, so a new window won't work.

TIA,

Heather

[quillpro]

So in each student record you want to see all other students of the same grade in a portal?

[hlabonte]

Not necessarily. I just want to display the current found set in the portal. It can be based on grade, name, class, etc.

I already have a portal working for displaying other records related to the current student. I should have said my main table is not students, but rather classes.

Is that doable?

[comment]

A portal displays related records. A relationship ignores the found set. The only way to display the found set in a portal is to mark the records in the current found set, and base your relationship on the mark field.

[Ender]

Marking the found set would be a problem in a multi-user environment. A better solution is to put the found set's keys into a field, and use that for a self-join. Check out Ray's 'Displaying Found Set in a Portal' demo:

http://www.nightwing.com.au/FileMaker/demos5.html