Hi Andy,

> I've tried it in the constraint editor and in a script editor with
> the same result.
> At the moment I try to create the Foreign Key there is only one
> editor open.

When creating FKs, only a single connection is allowed. In order
to provide multi-threaded-ness in the SQL Editor, Database
Workbench creates an additional connection. If you're creating
a foreign key - this will fail.

Either:
- close all SQL Editors/data tabs before using the Constraint Editor
or
- go to "Preferences, DB Specific, Firebird" and uncheck "Use
a single connection per SQL Editor"

And then try the Constraint Editor again.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com