I have a two tables in a Parent/child relationship and another one to store some values from both.(lets call it table C)
What I want to achieve is when I insert a record in the parent table, a row is inserted in table C.When the parent record is updated,the row in C is also updated.
And when the first child row is created, the same row is updated with the child details.
When another child row is created,the first row in C is duplicated with details of the Parent table and the values of the new child rows.
I also want when the parent row is deleted ,all child rows are deleted(accomplished already using cascading referencial integrity) - but need the rows in table C to remove the deleted child and parent data.
Thanks In Advance