> 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.

>

Well - this is exactly the reason to create check and foreign key
constraints.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."