Re: update pk referenced by fk
From: Polyphase <polyphase_at_aol.com>
Date: 24 Feb 1995 22:00:16 -0500
Message-ID: <3im6g0$298_at_newsbf02.news.aol.com>
Date: 24 Feb 1995 22:00:16 -0500
Message-ID: <3im6g0$298_at_newsbf02.news.aol.com>
Robert,
I agree with the other reply you received to some extent. The problem is that you are trying to change a primary key, which violates relational theory, whence the problem. What you may want to do is create a new field (call it ID) that is really your primary key and the value never changes. Then you could still maintain the pk-fk constraints on this new field, while allowing you to modify the "descriptive" fileds you are currently using as described in the other reply you received.
Good Luck,
Roger Larson
Roger Larson
Polyphase Corporation
Principal Consultant 919 E.
Schirra Drive
Palatine, IL 60067
Chicago's Best Source for Data Base 708/358-7912
Consultants email:
polyphase_at_aol.com
Received on Sat Feb 25 1995 - 04:00:16 CET