Subject Re: [ib-support] Foreign Key
Author Helen Borrie
At 03:30 AM 11/04/2003 +0100, you wrote:
>Hi,
>
>I have the folowing foreign key (Hotel,Epoca) with table Epocas that have
>Primary Key (Hotel,Codigo). Firebird permit Hotel field filled but Epoca
>with null value. This is correct or a bug?
>
>Hotel | Epoca
>1 null
>2 Alta
>
>Thanks,
>
>Miguel Goncalves

You cannot make a foreign key using split keys. The dependent table must
have referencing columns that match the primary key of the REFERENCES table.

heLen