Page 239 - IT_V1.0_Class10
P. 239
Notes
If the Add Tables dialog box not opens in the Relation Design window, then, you can open it by clicking
the Add Tables button in the Standard toolbar or clicking the Insert → Add Tables option from the
Menu bar.
Step 3: Select the Student table from the Add Tables dialog box.
Step 4: Click on the Add button. The table namely Student gets displayed with all fields.
Similarly, you can add the Student_Marks table to set the relationship between them.
3
4
Step 5: Click on the Close button in the Add Tables dialog box.
Step 6: Click on ROLL_NO field, i.e., primary key field of the Student table. Keep the mouse button
pressed and drag it over the ROLL_NO of second table, i.e., foreign key of another table namely
Student_Marks and then release the mouse button. The relationship between the Student and
Student_Marks table is established.
Step 7: Right-click on the Relationship Set line.
Step 8: Select the Edit option from the context menu. To open the Relations box for advanced relationship
settings.
7
Relationship set 8
between two
tables.
The Relations dialog box appears.
Step 9: Click on the Update cascade radio button to activate the update option and Delete cascade radio
button to activate delete option.
Working with Multiple Tables 237

