If you have a 2 records in a table that need be merged into one due to a
data entry error, and both of them have several child records in other
tables in the database, all with enforced referrential integrity there
doesn't seem to be a way for the database to preseve the children. It seems
that you have to manually find out what all the child tables are, then
update all the foreign key fields individually. If however, you just want to
delete a record, then all the children can be deleted automatically.

Does any database support a feature to help here, and if so, can it be
implimented in FireBird?

Thanks,

Robert Munro