Record Checking

[jbullydawg]

I have a database that tracks CEUs for teachers and have a question regarding how to script something.

I have a Course table and a Student table. To bring them together I created a registration table for the purposes of placing students in their registered courses. I want to be able to check that a student is not registered for the same course more than once at the time the student is registered.

For example, I have already been registered for Course X but a colleague of mine doesn't know that and tries to enroll me in the same course. What check can be run so that my colleague is notified of the duplication?

Thanks!!

[sbg2]

Validate a calc field to be unique:

IDStudent & "|" & IDCourse & "|" & IDTerm

You need the Term (or semester or...) in there to be sure to allow someone to retake a course.

Edited November 30, 2007 by Guest