On delete cascade implementation

[shan_cool]

hi all,

i hav "proj" table in which i hav set project code field as primary key. And in "member" table i hav the same project code as forign key... they r linked... If i delete the project code in parent table thn alll records in child table having that same project code should be deleted automatically.. if i delete individually in the child table only that record should be deleted.. plz let me know how to implement this?

 

Thx in Advance,

Shan,

Chennai,India.........