Subject Re: [ib-support] Can't insert foreign key constraint
Author Helen Borrie
At 10:03 PM 07-10-01 +0200, you wrote:
>I switched back to Build 156 (Beta1) and to Test1 from December2000. Both
>with the same error.

Some more thoughts...

Is it possible that one of the columns in the primary key of the child table has a dependency that links it circularly to the referenced table?

If it is essential to have both of these columns to get a unique row, why not use a surrogate primary key and place a UNIQUE constraint over these two columns? This should free whatever dependency is preventing the formation of the foreign key relationship.