>Hi,
>
>What is a better practice when deleting a record in a table (that has FKs), in code (VFP code) or with a trigger in SQL Server?
>
>TIA.
In SSMS you can set relations to CASCADE deletes on FK records. I prefer that although I'm sure there are circumstances where that would be a bad thing.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________