trigger help please

I need to some help creating a trigger. I have a table and I need an insert trigger when I try to insert something in table 1.. it makes sure that the value exists in table 2.. more sepcifically.

Table 2 is a list of courses and pre-requisites for each course.

Table 1 is a registration table. The user should not be able to sign up for a course if they have not taken the pre-requistie course

Table 3 has the list of courses that the student has taken.

thanks.

skippy Received on Sun Sep 29 2002 - 19:46:08 CDT