Subject Constraints - Cascade Delete from multiple parent tables
Author Venus Software Operations
Hi all

I have tried but was not successful.

- I have a transaction table.
- This table receives entries (internally generated from the app) from
multiple parent tables.
- Any one record will definitely belong to one parent table.
- The FK field name is iPID
- This FK field combined with a cSource field (which contains a few
identifying characters for each parent table like ! or @ and so on) will
always provide a unique identification even if iPID contains same value
- When a record is deleted in a parent table (PK = iID) I want it to
cascade the delete in this transaction table

Is this possible? If so please let me know how to make such constraints
in the transaction table.

Thanking you and wishing everybody a Happy New Year.