advanced microsoft access training courses in london - 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