Jump to content

What file should a field be in?


susan

This topic is 8126 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8126 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.