Page 241 - IT_V1.0_Class10
P. 241
Step 4: Click on the Close button in the Table Data View
window to close it. Follow the above steps to add a
similar number of records in the Student_Marks
table as added in the Student table, otherwise
Student_Marks table will not be saved.
Step 5: Double-click on the Student table from the Tables
pane to delete records from the table. The table
opens in Table Data View mode.
Records added in Student_Marks table
Step 6: Right-click on the record that you want to delete. In
our case, we have right-clicked the record where the
ROLL No. is 18.
Step 7: Select the Delete Rows option from the context menu.
Step 8: Select the Yes button to delete the record.
6
7
8
The selected record gets deleted from the Student table and the related record will be automatically deleted
from the Student_Marks table also.
Working with Multiple Tables 239

