|
Posted by CK on 03/17/06 19:16
I have a one to many relationship between a billing table and a task table.
I want to write a procedure I can pass a billingID to and it will go delete
all the task records with that billingID as well as the as the single
billing record. Like referential integrity.
There are two other task tables taskcharge and taskfunding. When I delete a
task from the task table I want to delete the related records from those two
tables as well.
Bottom line, I want to delete a billing record then delete then child
records in the task table, as they are deleted I need to delete the
taskcharge and taskfunding records child records of the task. The task table
has the billingID field and a taskID field. The taskcharge and taskfunding
tables have the taskID field only.
Can this be done? I suggested trying triggers but this customer doesn't want
to use triggers in delete operations. How do I accomplish this.
Any advice is appreciated.
Thanks in Advance,
CK
Navigation:
[Reply to this message]
|