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

