Re: Relation problem

From: <MSherrill_at_compuserve.com>
Date: Thu, 25 Jan 2001 07:02:14 GMT
Message-ID: <3a6fce2d.18826190@news.compuserve.com>

On 23 Jan 2001 12:25:06 GMT, hidders_at_REMOVE.THIS.win.tue.nl (Jan Hidders) wrote:

>I am not sure I understand this. If an organization is deleted/inserted
>then you also have to delete/insert it in the Parties table, otherwise
>referential integrity is compromised.

Assuming that Parties is the supertype, you delete an organization by deleting a row from the table Parties (and by logically cascading that delete through the foreign key references in other tables). Deleting a row from Organizations removes a detail about the organization, not the organization itself.

-- 
Mike Sherrill
Information Management Systems

Received on Thu Jan 25 2001 - 01:02:14 CST