I've checked with all related tables. There aren't any:
1) NULL values in key columns
2) Values in the child table which doesn't exist in the parent table

Is it safe If I try to do another backup (while de-activating the
index for this foreign key), and perform another restore? I'm kinda
lost now.

On 6/21/05, apairudin <apairudin@...> wrote:
> >
> > Is there another table that uses T_INV_ITEM_LOT as the referenced table
> > and LOTID as its foreign key?
> >
>
> Hi,
>
> Yes, there are 10 other tables which dependends on LOTID.T_INV_ITEM_LOT.
>
> Regards,
> Faisal
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ________________________________
> Yahoo! Groups Links
>
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


--
There are many ways of going forward, but there is only one way of
standing still.