hi all, i have this project to build a crm application. my sales order
table has a foreign key referenced to the customer table. my problem
is that, everytime i try to delete a customer record, i got this
"foreign key" exception. how do i know that this customer record is
not referenced to the sales order record before the user press the
delete button?

i use firebird 2 and delphi 7

any comments will be highly appreciated

thanks

rey