Delete records from three tables in sql server

Question

In my asp.net Web application, I have 3 tables Table 1,Table 2 and Table 3.

 

Table 1            Table 2                   Table 3

  Id                    AudioId                 AudioId        

AudioName      AudioName           AudioName

 

 These are my Tables and contains fields here Table 1 Id is same as AudioId in Table 2 and Table 3. Here based on Table 1 Id when i select that record and click delete it automatically delete that Id based on records in  table 2 and table 3.

 

How can i do this can anyone please help me out.

 

Thank you