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.
>

Then the error, almost certainly, is that one of those tables has a
record with a LOTID not represented in T_INV_ITEM_LOT. If the database
is still available, find and fix that problem. If not, the ibsurgeon
people can probably help.


Regards,


Ann