Hi,
i have 2 table, table A and table B.

Table A have a unique-primaryKey (PK_A) and some other fields.
Table B have a unique-primaryKey (PK_B) some other fields and a field
who is ForeignKey (FK_B) referenced to PK_A. The constraint are
defined as ON UPDATE CASCADE ON DELETE NO ACTION.

I need to delete one or more record from Table A because are copy of
other existing record (but of course have differnt PK_A).
But before delete my records i must change all the foreignkey (FK_B)
to the record of table A who remain.

Interbase can do this for me using the referential integrity
constraints? Or can i use some other method?

Of course i have a lot of this constraints in my real database...

Best regards,
Enrico Raviglione.