V
Virnocis
I'm fairly new to Access, and I'm trying to create a database with
multiple relationships. This is what I want to do:
Search a student to find:
The Class they are in
The location of the class
The Instructor who taught
The week the class was taught
The name of the workshop
I want to be able to search all of these fields for the match. Another
example would be:
Search an instructor to find:
The Classes they taught
The location and date of those classes as well as the workshop name
The students who attended those classes.
I've been trying to Use the Class as the junction table with the
following IDs:
ClassID
DateID
LocationID
InstructorID
WorkshopID
The problem I'm having is when it comes to class IDs and relating them
to the other tables. Since both instructors, students, and dates can
have many class IDs.
What I tried to do was assign multiple class IDs to the students,
instructors and dates, and it looks like this:
for dates:
dateID weekdate ClassID1 ClassID2 ClassID3 ClassID4
for students:
StudentID ......... ClassID1 ClassID2
and for instructors:
InstructorID ....... ClassID1...ClassID3...
lassID6...ClassID8...ClassID10
I'm having problems with ClassID matching with all the other columns,
and I don't know what to do. Can anyone help? thanks.
multiple relationships. This is what I want to do:
Search a student to find:
The Class they are in
The location of the class
The Instructor who taught
The week the class was taught
The name of the workshop
I want to be able to search all of these fields for the match. Another
example would be:
Search an instructor to find:
The Classes they taught
The location and date of those classes as well as the workshop name
The students who attended those classes.
I've been trying to Use the Class as the junction table with the
following IDs:
ClassID
DateID
LocationID
InstructorID
WorkshopID
The problem I'm having is when it comes to class IDs and relating them
to the other tables. Since both instructors, students, and dates can
have many class IDs.
What I tried to do was assign multiple class IDs to the students,
instructors and dates, and it looks like this:
for dates:
dateID weekdate ClassID1 ClassID2 ClassID3 ClassID4
for students:
StudentID ......... ClassID1 ClassID2
and for instructors:
InstructorID ....... ClassID1...ClassID3...
lassID6...ClassID8...ClassID10
I'm having problems with ClassID matching with all the other columns,
and I don't know what to do. Can anyone help? thanks.