Jump to content

Any help on this would be great


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

Recommended Posts

I am a systems manager new to a school and I am currently creating a database of student records as well as schedules of each class. The way my database is setup is one layout that would contain that student will all information classes, grades, first name, last name broken up into 12 quarters. Then separate layout for each quarter for grades classes, class location, teacher, and day, ECT.

Example:

Jim Smith

Class name Time Day Teacher Grade Classroom Math 1 4-7 Tuesday Bill 10 201

Science 5-8 Wed Mary 10 202

History 7-10 Thursday Jake 10 219

The problem I am having is that the fields

Link to comment
Share on other sites

quote:

Originally posted by RET:

I would like to make this easier and just be able to pick a class, day, time, teacher and classroom and add all the students into it maybe from a value list or something. Then when I went to this student ? Jim Smith? I would automatically have a schedule filled out.

Then start with the "Class" record and fill in the information from there. You will need a join file between Student and Class which would contain the ClassID and the StudentID.

Once all of the class information is filled in and the students are joined to it, then looking at the particular student, you will have thier entire schedule.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

This topic is 8542 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.