Re: trigger help please

Hi Skippy,

In Australia, a combination of Skippys and Triggers results in a lot of dead Kangaroos ;)

Students (and posters in general) get a better response when they at least attempt to solve the assignments themselves.

Show us some code and your attempt at this and I'm sure someone will give you a pointer to what might be wrong.

Cheers

Richard
"Skippy" <SkippyNOSPAM_at_hotmail.com> wrote in message news:an86s2$3mo$1_at_slb7.atl.mindspring.net...
> 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 Mon Sep 30 2002 - 07:17:48 CDT