foreign key related

Hi all

I am stuck up in a very small problem

if i have got a combined primary key of 3 fields(f1 f2 f3) in one table (lets say tab1)
and in another table (lets say tab2(field1,field2) ) i want one of the fields (from tab1) as the foreign key here in tab2 (lets say field1 references tab1(f1) )...

is it possible because f1 is not the primary key its a part of the primary key of table tab1

hope i m clear with the problem

Regards and Thanks in advance
Parvinder Received on Mon Nov 29 1999 - 07:58:30 CST