cascade update explanation

  • Thread starter Thread starter larpup
  • Start date Start date
L

larpup

If I have a form with a Parent table attached to a child table (many to
one), I want to delete the child when the parent is deleted, so I use
cascade delete. When would I use cascade update and why would I use it.

Any info is appreciated.

Lar
 
larpup said:
If I have a form with a Parent table attached to a child table (many
to one), I want to delete the child when the parent is deleted, so I
use cascade delete. When would I use cascade update and why would I
use it.

Any info is appreciated.

Lar
Click to expand...

Normally used when you have a natural key field in the parent table (not a
surrogate like AutoNumber) which is also used as the foreign key in a child
table. If a parent key field ever needs to be changed then that change (or
update) is cascaded to all related child records automatically.
 
Thanks Rick,

This doesn't mean that if I delete a child record, it will delete the
parent, correct?

Lar
 
larpup said:
Thanks Rick,

This doesn't mean that if I delete a child record, it will delete the
parent, correct?

Lar
Click to expand...

Not at all. ALL cascading is "downhill only" meaning parent to child.
 
Back
Top