Gustav Brock
Gustav at cactus.dk
Fri Feb 3 10:08:27 CST 2006
Hi Reuben Well, you didn't do your homework ... But as you note, it is very easy to correct: Enforce Referential Integrity and turn OFF Cascade Delete between Employee and Employee Journals (or whatever the details are). This way you don't need to do anything else. If a journal exists, the Employee of that can not be deleted no matter what the user do - not even if he/she has table level access. Very powerful. /gustav >>> reuben at gfconsultants.com 03-02-2006 16:47:40 >>> I think John nailed it. Check all relations to this table. Just yesterday I had to restore about 14,000 expense records because she had deleted an employee rather than "terminating" (which means enter the date the employee was terminated) that employee. Cascade Delete is very powerful, which makes it very scary. I now have two things to change in my app - a relation property and to not allow deletes of employees. Reuben Cummings GFC, LLC 812.523.1017