First off all candidate id in the first table had primay key and after all the table have foregion key..When i have try to delete any row of tblcandidate personal...

i have foloowing tables....

tblcandidatepersonal

tblCandidateCategory

tblCandidateEducation

tblCandidateIndustry

tblCandidatePreferredLocation

tblCandidateResume

tblCandidateSkills

tblCandidateWork

tblCandidateCertificate

The main data remove in tblcandidatepersonal but these all details are these eight table...