Deleting a record

I have three tables

1. membership table(aspnet_membership table)

2. User Contacts table

3. Address table

These three table have relation ship with one another through a UserId field.

How will you set up cascaded delete on these tables, Like if I delete a user in the membership table I want the related records in the other tables to be deleted as well. Cascaded delete is it something done through code, or is it definde when the tables are created.

Please advice.

bendJoe:

is it definde when the tables are created.

Yes, you should define it when you create the tables. You can also use theALTER TABLE command if you want to add to existing tables.