Portal Filter - Redux

[Jacob]

I've got a question similar to the portal filter post already underway. I too would like to filter my portal results using a global and a second TO. The problem is, I want the filter to be a calculation.

Specifics: I have a scholarships database. In one layout I would like two portals - the first shows all the scholarship information for each student, that's easy. The second will have the same information BUT will only show the scholarships for the current school year (Fall 2005 - summer 2006). I need also to be able to grab just those scholarships from this year and then insert then into another layout used for printing purposes. Can I filter this way with a calc, or do I need some other, easier solution?

[RalphL]

If you have a calculation on both sides of the relationship, it must be stored in the related table. I wonder why you need a calculation since you are using FMP7.