What file should a field be in?

[susan]

I'm working on a report card. I have 2 files, Students and Skills which are related via student_id. Students holds student name, id, and grad year. Skills holds student id, grade, skill, score, and school year. I enter the scores through a portal in Students.

I need to be able to assign each student a teacher, but since this will change every year, I don't want to do it in Students. However, there is more than one teacher for each grade, so I don't think I can do it in Skills.

What I would like to do is be able to enter a teachers name/school year and get that teacher's class list for that year with the appropriate skills.

How do I do this?

Thanks.

Susan

[Chuck]

It sounds like you need a join file between the Students and the Teachers, since it's a many-to-many relationship (one student can be linked to many teachers, one teacher can be linked to many students). This file might consist of nothing more than a StudentID and a TeacherID. The Students file would view into this file with a portal based on the StudentID and the Teachers file would view into it with a portal based on the TeacherID.

Chuck