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
   236   237   238   239   240   241   242   243   244   245   246