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.

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...