cascade update explanation

[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

 

[Rick Brandt]

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

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.

 

[larpup]

Thanks Rick,

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

Lar

 

[Rick Brandt]

Thanks Rick,

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

Lar

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