Yes and No.

If I put On Delete Cascade on the two FK, when I delete a customer then the CustomerAddress delete also (it is for the Yes).

But never...

Thanks Steve for your answer.

It is true that solution 2 is better...

Hi,

I am also new in sql and i have the same issue but with addresses for several entities.

Could you detailed if i have the following tables :

tblCustomer

CustomerID (PK)

CustomerName

(other fields)

tblSupplier

SupplierID (PK)

SupplierName

(other...