I have a problem to delete record in Table A, since the table have relation to Table B. For example,
Table A = StudentMarks
Table B = StudentData
StudentID Name Class
1 John 1A
2 Calvin 1A
3 Kelly 2B
* I want to delete the StudentMarks in class 1A. The "StudentID" is the foreign key which related to TableB to get the "Class".
Is it possible to do that? Any help will be appreciate.