Hi,
using oracle 11.2.0.3
Have a table lets call it table a with pk column.
Have another table, table b with fk column pointing to table a with cascade delete option set such that if delete row in table a, all associated rows in table b deleted.
Have table c which has 2 columns only 1 of which populated (collected or delivered id indicating if a collection or delivery call not my design! would have had 1 populated and call type ) and these have fk pointing to table b (calls table).
Can you have cascade delete on table c fks such that if row deleted in table a which automtically deletes associated rows from table b, in turn the table c rows associated with table b are also deleted.
Thanks