microsoft+access+training - Microsoft Access - refferential integrity | Access forum

Hi Dave,

Referential integrity is used where you have a number of linked tables i.e. customer and order.

If you want to delete a customer you would generally want to delete all the orders that belong to that customer. Thus by enforcing referential integrity Microsoft Access would automatically delete all orders when you delete a customer.

However if you want to keep all of the records that belong to a customer you must NOT enforce referencial integrity within Microsoft Access.

Hope this helps you out with Microsoft Access.
David