> David,
> This is reminiscent of an old thread that circulated around the old

Mers

> list more than once, wrt to IB 5.x. AFAIK, the error message is
> misleading, insofar as it implies that you can form a foreign key that

> refers to a unique index. I believe in FB/IB, this is not the whole
> story. A foreign key has to refer the primary key of the reference

table

> (which, by definition, has a unique index...) It should be telling

you

> "could not find PRIMARY KEY with specified columns".

or UNIQUE constraint... for that matter...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com