Table Query

[Newbie11]

I have a table that has severl different courses a student can take. Each is identified by an auto id. I also have a student table that lists each indidual student. What I would like to be able to do is create a status query that identifies where each student currently at, this can include a course from the course list or the status of graduated or withdrew. How can i create a table or query that combines all the courses and the graudated and withdrew statuses into a single field list?

[orange]

First you have to write down the details so we can understand your situation.

A student may be in school or not.
if in school then he/she will be in a course
if not in school he/she may have graduated or
                      he/she may have withdrawn
A course is contained in a List of Courses

Do these make any sense? Should they be adjusted?

[Newbie11]

That is exaclty right. Sorry I didn't include that. Even if the student is or isn't enrolled I want to include their status (course name or othwerwise) in a single field. I'm not sure if need another table with withdrawn, graudated and then merge these two together someway?

[orange]

I think these tables and attributes would be appropriate


Student
StudentId PK
StudentName
StudentAddress

StudentCourse
EnrollmentId PK
StudentId FK to Student
CourseId FK to Course
EnrollmentDate
StatusId FK to StatusCodes

Course
CourseId PK
CourseName
OtherCourseInfo


StatusCodes
StatusId PK
StatusName


StatusCode Values (Enrolled, Withdrew, Graduated)

[Newbie11]

Thanks! That makes things a lot clearer.