ForeignKey constraint

From: Actiris <actiris_at_cscoms.com>
Date: Mon, 12 Feb 2001 14:47:40 +0700
Message-ID: <9684q2$1a6$1@news.cscoms.com>

Can't find the correct way to define a foreign key constraint which refers to 2 fields.

Table1: (PrimaryKey are 2 Fields)

Field1_1 constraint CFK_Field1        references TableX(FieldX)
Field1_2
Field1_3

constraint CPR_Key1 primary key (Field1_1, Field1_2) );

Table5:

Field5_1
Field5_2
Field5_3  constraint CFK_Field5_3   references TABLE1(Field1_1, Field1_2) );

----->> This doesn't work because there can be only one field be
referenced. How to do it otherwise?

Many thanks in advance
Beat

--
+++
Beat Christen        actiris_at_loxinfo.co.th
Phuket/Thailand
+++

Received on Mon Feb 12 2001 - 01:47:40 CST