EURREKAA! It works.

Thanks Helen and Martijn.

This was a long standing problem, as I very rarely use foreign keys while developing the program. Most of my integrity checks are through the frontend (Delphi) - and usually I forget some checks and invalid data slips through into the database.

Thanx again.

Sujan Sreenath