Primary/foreign key problems
From: <rkalch_at_my-dejanews.com>
Date: Wed, 14 Oct 1998 14:28:27 GMT
Message-ID: <702ceb$584$1_at_nnrp1.dejanews.com>
This is the error:
Date: Wed, 14 Oct 1998 14:28:27 GMT
Message-ID: <702ceb$584$1_at_nnrp1.dejanews.com>
This is the error:
ERROR at line 1:
[Quoted] ORA-02294: cannot add referential constraint - parent keys not found
and this is what I'm trying to do:
ALTER TABLE ORDERS1
ADD FOREIGN KEY (MFR, PRODUCT)
REFERENCES PRODUCTS1 (MFR_ID, PRODUCT_ID);
I already added a primary key for PRODUCTS1 (MFR_ID, PRODUCT_ID) and the table
was altered successfully.
I would welcome any help.
[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Oct 14 1998 - 16:28:27 CEST