> Catch the exception, report the problem to the user and then cancel
> the operation. Delphi is very good at handling exceptions and this
> is by far the most efficient way to do it.

i guess you're right. but im just curious if there's a way or query to
get active foreign key of the customer record.

i've read an article
(http://www.alberton.info/firebird_sql_meta_info.html) on how to get
the list of foreign keys from the system tables. but still doesn't
tell me whether the current customer record has foreign key references
present.

thanks

rey