>The code you showed will require me to change tons of code in my application. If I remove constraints I won't have orphans since I "enforce" the constraint in my code. The Constraint in SQL Server would be nice as it would be another safety check. But I will have to live with just my VFP code checking for the constraint. It is not the best approach, of course.
True. Also, you will not be able to guarantee integrity of your data if you rely on only application code. On the other hand, in our application we also use not enforced constraints relying on application to handle data integrity and have the same risk as you will.
If it's not broken, fix it until it is.
My Blog