98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Low Priority · Version 2003
Tue 3 Mar 2009, 16:08Delegate Andrew said...
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?!
Thu 5 Mar 2009, 15:46Trainer Simon said...
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
Thu 12 Mar 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Splittng a databaseSplit your database into two (at least). |
