Yeah removing a second index on the field helped. Thanks Martijn. I'm still
interested however in the standard code that people normally use for
creating foreign keys, whether it be with CREATE TABLE or ALTER TABLE.

I'm sure this is something many of you do on a regular basis and it would
help me who is not a Firebird expert.

Thanks,
Stephen

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, June 27, 2002 3:22 PM
Subject: Re: [ib-support] Implementing referential integrity


> Hi,
>
> Well, if this is the only meta data changes you did, then I would say
> that either CODING_ID is not a primary or unique constraint in the
> CODING table. Or (which, btw, is a small bug) you have additional
> indices on the CODING.CODING_ID field.