It was, in my case, relation, that in ER-diagrams has name "Incomplete
subtype cluster". I need in table Obj marks about not only Org
(Organization, #Org_ID), but copies of rows from another tables (for example
Product(#Prod_ID)). For that I use same sequence for Product and Org primary
key fields and triggers for both tables that insert rows in Obj table by
insertion of rows in Product and Org. And I need backward action - by
deletion from Product or Org I need to delete row from Obj. Both tables (Org
and Product) references to table Obj. Insert and Update triggers work
normally. Any suggestions? "On delete cascade" clause works in Master-Detail
direction, I need backward action (Detail-Master).
Valentine
Received on Mon Dec 07 1998 - 07:55:04 CST
