How to implement "on delete cascade" semantics with ADF
313177Mar 27 2012 — edited Mar 28 2012Hello,
We have the need to ensure that children objects are cleaned up when parent data is removed. The foreign key relationship has been properly setup, but I am not sure how what needs to be done to enforce "on delete cascade".
In our EO for the relevant foreign key, I found that the "on delete" selection is set to "restrict". One of the "on delete" options is "cascade", do I simply switch to select "cascade" and that'd take care of the requirement?
I'd appreciate your input as to what is the recommended fusion mechanism in implementing on delete cascade.
thanks,
Joe