Re: Simple foreign key question

From: <seanldus_at_my-deja.com>
Date: Fri, 22 Dec 2000 18:03:01 GMT
Message-ID: <92050g$j38$1@nnrp1.deja.com>

Hi Dave,

Thanks for the answer. That was sort of a sanity check. If you have a field in one table which cannot be uniqe, but has to be there in order to exist in another table, I have to use a trigger? Maybe you have run in to this before?

In article <91u7uc$7jl$1_at_news3.cadvision.com>, "Dave Haas" <davehaas_at_hotmail.com> wrote:
> Sean. A foreign key REQUIRES either a unique or primary key to point
to.
>
> Regards,
>
> Dave Haas
>
> <seanldus_at_my-deja.com> wrote in message news:91u5s6
$35r$1_at_nnrp1.deja.com...
> > Am I missing something? Can I create a foreign key that references
a
> > column that is not a primary or unique key?
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 22 2000 - 12:03:01 CST