Page 274 - IT 402 v2.0 class 10
P. 274

Step 12:  lick on the  Save  icon from the standard toolbar to save the relationship.

        Step 13: Click here to save the relationship.









                      13





















         he relationship between the S    N  and S    N M   S is set. Since the relationship between the tables
        is set with S    N  table to S    N M   S table  so updating or deleting records from S    N  table will
        automatically update delete records from S    N M   S table.

         ut if one tries to update records from S    N M   S table  then an error message will be displayed and it
        will not allow to update records from the S    N M   S table.

        Now  let us see how relationship works.

        Step 1:   ouble-click on  S    N   table from the   able  indow  pane to add records in the table.
        Step 2:   he table opens in   ata  iew  mode. Now  add a few records in the  S    N   table.

        Step 3:  Save the table  S    N  .













                                               Records added in STUDENT table





        Follow the above steps to add similar number of records in the S    N M   S table as added in the
        S    N  table  otherwise S    N M   S table will not be saved.








         272       Touchpad Information Technology-X
   269   270   271   272   273   274   275   276   277   278   279