Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access training courses in london - Referential Integrity
|
|
|
Bookmark this page|
The UK's most regular 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. |
advanced microsoft access training courses in london - Referential Integrity
Resolved · Low Priority · Version Standard
Reply
Referential Integrity
Should you always enforce referential integrity when setting up relationships between tables? What would be an example if you didn't?For upcoming training course dates see: Pricing & availability
RE: Referential Integrity
Hi Brian.No, you should not ALWAYS enforce referntial integrity between relationships.
Using ORDERS and CUSTOMERS tables for example:
Generally it is a good idea to enforce it one way - IE. Customer record must exist for order to be created.
You might choose not to enforce the other way - IE. If Iyou delete a customer, there is no need to delete all the orders relating to it (for record keeping), or if you delete an order, you do not want the customer to be deleted too.
Does that clarify it for you?
Richard
|
 |
|
» Forum post: Advanced training |
Very useful course - i'm sure i'll be back asking questions about Pivot tables at a later stage though!
