conditional foreign key constraint

Hi,

I want to create a foreign key constraint which is only checked when a certain value in one of the field is set. such that I have a field called STATUS and when the value equals 1 then my foreign key is active on that row. I guess this is not really possible without a trigger but a trigger would take forever as I have thousands of rows. has anyone had something similar and has an idea of how I could perhaps do this.

Thanks in advance
cookie. Received on Wed Jan 14 2004 - 08:30:01 CST