By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

Using my experience as a model, I'd like to show how you can approach any new customer's problems using Eliyahu Goldratt's theory of constraints.