Andrew has attended:
Access Intermediate course
Access
why is the sky blue some days and not blue on others even though there appears to be no clouds?!
Okay for real now:
Why is it so important to cascade delete update records, would this not be inappropriate when dealing with health records - please elaborate and explain some rules for application of table linkage?!
RE: Access
Hi Andrew,
Thank you for your question.
It is an option when you are linking tables but the case you talk about it, it would not be appropriate as you would want to keep the data.
It may be more appropriate to archive the old data rather than using cascade delete related records.
This option should possibly only be used by Senior Developers or Managers when there is no need to keep the old data.
I hope this answers your question.
Regards
Simon
