RET Posted January 4, 2001 Posted January 4, 2001 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
Kurt Knippel Posted January 4, 2001 Posted January 4, 2001 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 =-=-=-=-=-=-=-=-=-=-=-=-=
Recommended Posts
This topic is 8976 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 accountSign in
Already have an account? Sign in here.
Sign In Now