hfsnell wrote:

> I don't know how it can happen!
> I have a database which has many table.
> There is a foreign key such as A --> B.
> After some month my database crashes, I investigated and found out that
> there many row in A but the key column is not in B.
> Plz help me. I am using FB 1.5.3 on WinXP

Personally, I'd need a lot more detalied and specific info to be able to
help.

Isolate the two tables and the FK relation that you apparently violate.

Give us the table defs and the FK constraint definition.

Tell us what you (your application) is trying to insert or update.

For a start...

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64