found out what was happening, the developer had data in the table that
would not be allowed by the FK, hence the exception. (SFX of smacking
developer round head when he says "does it matter if there is data in
the table").

Why the error message was scrambled I don't know as there is only one
firebird.msg file on that machine.