Foreign Key Question
From: Chuck B <chuck_jen49_at_yahoo.com>
Date: 21 Jan 2002 19:39:32 -0800
Message-ID: <b1245bc4.0201211939.69464bf1_at_posting.google.com>
Date: 21 Jan 2002 19:39:32 -0800
Message-ID: <b1245bc4.0201211939.69464bf1_at_posting.google.com>
A simple question that I think I already know the answer to but I'll
ask anyway.
If I have a multi column primary key, can a foreign key reference a
single column of that primary key? If so, how do you code it? Every
way I have tried returns a 02270 error. If no, is there another way I
can accomplish something similar such as a simple select in a CHECK
constraint?
Thanks,