on 26/11/02 3:46 PM, Faisal Abdullah ([EMAIL PROTECTED]) wrote: > Lets say I have a table called 'employees', and another table called > 'training_history'. > > Lets say I need to delete an employee, I would also have to delete his > record in the 'training_history' table.
The employee would (I assume) have a unique id/key... presumably this key relates his/her information in the training table. employee: id/first/last/email training employeeid/something/something So, when you delete the employee with id '15', also delete any training records with the employeeID of '15'. So, yes, I'd do this at an application level... although I have no idea what triggers are :) Justin French -------------------- http://Indent.com.au Web Development & Graphic Design -------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
