Newbie: how do I add historical data?

[smith]

I have a school assessment database that has all the students and their grades and their teacher's name for one school year. How do I set it up to add previous year's assesments and previous year's teacher info, as well as future years so that a student's history of assessments can be displayed on one page? New to FileMaker and our school district does not have the funding to upgrade to version 8.0.

[overrider]

hey,

just have two files:

1. people

2. grades

now when you add a record in the grades table, you have a field there called creation_date, which contains the creation date of the record. this way later you can easy search for one year, and the display the results....

do you know my meaning? i could post a simple example file if you need...