Good morning,
I am trying to create an append qry that will take a student from tblStudent, and add them with all courses in tblCourses to tblStudentCourses. I have tried everything I know possible but it is not working. Here is my set up:

tblStudent
*alias
FName
LName

tblCourse
*CourseID
Course Disc

tblStudentCourses
SI (StudentID)
CI (CourseID)

I am trying to populate the tblStudentCourses with the student enrolled in all courses upon enrollment.

On what field does tblStudent relate to tblStudentCourses.

what, exactly is 'everything'? (Don't want to go giving you solutions that you've already tried (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Jim

I assume you have a form where you select the student and what to kick off the Append with an event (i.e. a command button).

You could use:

Dim strSQL As String

strSQL = "INSERT INTO tblStudentCourses (CourseID, StudentID) "
strSQL = strSQL & "SELECT CourseID, " & Me.StudentID & " AS StudentID FROM tblCourse;"

CurrentDB.Execute strSQL

That should add all the courses with the currently selected student.

The append qry I made only pulls the courses that the student is already enrolled in. I need the instructor to be able to put the student in all the courses and update start date and completed date as they go.