by I just want to make sure I got this straigt.
If I delete a parent record with child records, all
the child records are deleted also, (cascade in the delete
trigger). That's great.
Now, if I recall the parent record in order to reuse it for
a new parent, none of the child records is recalled and the
update trigger ignores those deleted child records, so the
next time I need to add a new child record for any existing
parent record, I can just recall it and change the foreign
key to what I need.
Do I have it right? Am I missing anything?
TIA
Bill