Subject foreign Key Deletion
Author Maurizio P.
hi ,
i searched hours , but i could not find any help so
i try to ask here (my first time) for an help :

i thought that normally it would not be possible to
delete a row which is a foreign key in another table ,

the example :

tableBanks
-idBAnk(PK)
-desBAnk

tableCustomers
-idCustomer(PK)
-desCustomer
-idBank (FK)
..ecc

in this situation i can delete every tableCustomer row , even if them
exists as FK in the second table ,
is it the normal behave ? how can i prevent it ?

i am using Firebird 1.5 with delphi , and i use IBExper for
the database design .

thanks

Mauro


[Non-text portions of this message have been removed]