April 8, 200520 yr 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
April 8, 200520 yr So in each student record you want to see all other students of the same grade in a portal?
April 8, 200520 yr Author 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?
April 8, 200520 yr 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.
April 8, 200520 yr 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
Create an account or sign in to comment