> I'm used to working with Access but have moved to MSSQL 2005.
> I have these tables:
>
> tblCustomer: customerID (auto), name (nvarchar,50)
> tblOrders: orderID (auto), customerID (int)
>
> I use SSMSE. How can I set it up so that the related records in tblOrders
> are deleted if I delete a customer.

> ALTER TABLE tblOrders ADD
>    CONSTRAINT fk_order_customers FOREIGN KEY (customerID)
>        REFERENCES tblCustomers (customerID) ON CASCADE DELETE
>
> Although, I must say that from my corners, this looks like a funny
> business rule...