Thanks for your reply.

I just response to the thread that Ann posted.
Hope you guys can gives me a light on how to go about it.

--- In ib-support@y..., "Darryl VanDorp" <dvandorp@w...> wrote:
> what are the table structures for the tables in question?
>
> -----Original Message-----
> From: hinfun@h... [mailto:hinfun@h...]
> Sent: Thursday, September 06, 2001 10:45 PM
> To: ib-support@y...
> Subject: [ib-support] Foreign Key - Firebird Beta 2
>
>
> I have problems creating foreign keys in IB.
> I have try this on the Interbase Open Edition and it doesn't work.
> This has been post to borland interbase newsgroup as well and
> apparently the certified version behaves the same according to
> respondents. I tried this on Firebird and it looks the same.
> I really doubt this is normal and hopefully there is a patch for
this.
>
>
> The problems as belows :
>
> I execute the foreign key from Interactive SQL : (this is just 1 of
> them)
>
> alter table AMX_TP_DATE_CONTROL
> add constraint fk_amx_2065 foreign key (COMPANY_CODE,
BRANCH_CODE)
> references AMX_BRANCH_TABLE (COMPANY_CODE, CODE)
> on delete cascade;
>
> It returns the following when executing the script :
> Attempt to store duplicate value (visible to active transactions) in
> unique index "RDB$INDEX_16"
>
>
> I have ensure the following :
> 1. There is no such foreign key created in the Database.
> 2. Clean Installation and generated around 8 tables which includes
> the 2
> above.
>
> Thanks
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/