OK, now I think we're getting somewhere.
As a summary, here are my 5 tables:
(1) tblPrograms
(2) tblCourses
(3) tblStudents
(4) tblLocations
(5) tblEnrollments - Enrollment ID, Course ID (FK), Student ID (FK),
Location ID (FK), Start Date, End Date
- all tables, excluding tblEnrollments, have some data entered already. When
I go to create the process for enrolling multiple students into 1 course, how
would I design the form?
(1) Should I simply base the main form on tblEnrollments and select a
CourseID, LocationID, Start and End Date, and then choose one student. Then
create a second record for the same course, location, start and end date, and
then choose the 2nd student (and so on, for all students in that course) -
duplication problem i would assume
OR
(2) Could I use the "Allow multiple selections" property - V2007 - so that I
can have one record of the course with multiple students.
OR
(3) Should I be going a different route?
- I don't need to store any information in the tblStudent regarding which
courses they are or have been enrolled in or in tblCourses regarding which
students have been enrolled currently or in the past - I will query
tblEnrollments for this information if needed at a later time.
This is the part that is confusing me. I am trying to avoid duplication in
tblEnrollments but at the same I would like a easy method to register 5 - 40
students in one course, in a particular location, with a specific start and
end date on one form only.
Thanks again.
"Gina Whipp" wrote:
> UnknownJoe,
>
> Then you should probably add LocationID to tblEnrollemnts. "Call" back if
> you need further help...
>
> Your welcome!
> Gina Whipp
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "UnknownJoe" <(E-Mail Removed)> wrote in message
> news:AF1EBE12-D7A0-407F-B910-(E-Mail Removed)...
> > Thanks Gina for your assistance.
> >
> > Essientally, each Program (i.e. 10 total Programs) has anywhere from 2 to
> > 50 Courses. I already have all the Programs entered into the DB and do not
> > need to do much with the Program Table any more.
> > For each record in the Enrollment table, I basically have to choose the
> > Course, Location (the Location is not attached to another table aside from
> > the enrollment table - many of the same courses occur in different
> > locations,
> > sometimes at the same time), and most importantly, be able to list all the
> > students who have signed up for the course.
> >
> > Thanks,
> >
> > David
> >
> > "Gina Whipp" wrote:
> >
> >> UnknownJoe,
> >>
> >> You're going to need an...
> >>
> >> tblEnrollments
> >> eStudentID (FK) - relate to tblStudents
> >> eProgramID (FK) - relate to tblPrograms or eCourseID (FK) - relate to
> >> tblCourses
> >> ....any other fields...
> >>
> >> If the Courses are tied to the Programs then use ProgramID or if the
> >> Programs are tied to the Courses etc... If they are seperate then add
> >> fields eProgramID and eCourseID. I am assuming that LocationID is tied
> >> to
> >> the either Course or Program???
> >>
> >> --
> >> Gina Whipp
> >>
> >> "I feel I have been denied critical, need to know, information!" -
> >> Tremors
> >> II
> >>
> >> http://www.regina-whipp.com/index_files/TipList.htm
> >>
> >> "UnknownJoe" <(E-Mail Removed)> wrote in message
> >> news:B689EB87-9E39-469E-820E-(E-Mail Removed)...
> >> > Hello,
> >> > I had a previous post on this topic but wanted to repost using some
> >> > different wording (thanks for the help "Beetle", just not getting
> >> > anywhere
> >> > at
> >> > the moment)
> >> >
> >> > Is there a general template or guide for designing a database that
> >> > allows
> >> > for input of students, programs and courses, AND allows for enrollment
> >> > of
> >> > students into the courses (same courses occur with different dates).
> >> >
> >> > I have the following at the moment:
> >> > (1) tblStudents - ID (PK), FName, LName
> >> > (2) tblPrograms - ID (PK), ProgramName
> >> > (3) tblCourses - ID (PK), CourseName
> >> > (4) tblLocations - ID (PK), LocationName
> >> >
> >> > I guess my biggest problem at the moment is the enrollment process and
> >> > the
> >> > preferred or recommended way to do so.
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
>
>
>
Similar Threads
