'Snapshot' calculation

[jtscott]

I have a database which produces students end-of-term report cards. I have an Overall Comment field which is made by concatenating a Course Outline from a related table and a teacher's comment, which is individual to each student. I also have a Year field, which records which year each report was created. The Course Outline is common to all students following a course in a particular academic year, but will change from year to year.

I want to be able to find last year's report cards and see them as they were - Course Outline and all - even if I've changed the Course Outline to suit the updated course this year. However, because the concatenated Overall Comment field includes an field from a related table, it won't let me store the results. Also, I need to keep the data live so that the new course outline comes up in only this year's report cards.

[Søren Dyhr]

I would make several multi criteria relations TOG's, each residing on threir own layouts, keep things in invisible portals. The criterias would include "distances" from todays date. All it then takes would be scripted flipping thru layouts.

--sd