Xref: alice comp.databases.oracle.misc:23712
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed.cwix.com!207.0.56.122!news.eli.net!not-for-mail
Message-ID: <367218CB.2AD11A19@2xtreme.net>
From: PMG <pete_g@2xtreme.net>
X-Mailer: Mozilla 4.5 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Propagating parent key change to child table
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 8
Date: Sat, 12 Dec 1998 07:18:31 GMT
X-Complaints-To: abuse@2xtreme.net
X-Trace: news.eli.net 913447111 209.63.215.67 (Sat, 12 Dec 1998 00:18:31 MDT)
NNTP-Posting-Date: Sat, 12 Dec 1998 00:18:31 MDT
Organization: 2xtreme.net NewsReader Service

What is the best way to set up the realtionship between parent table and
child table so that when one changes the parent table's PK the change is
propagated to automatically change the child table's FK?

TIA

Pete