Page 104 - iPrime_V2.2_class7
P. 104

Table named ‘StudentsMarks’ that holds information about Roll No, Marks and Percentage.













                                                   Using tables for defining relationships
                  To define the relationship between the two tables, follow these steps:

                  Step 1  Click  on the  Relationships command
                          from the Relationships group under the
                          Database Tools tab.

                  Step 2  The Show Table dialog box will open. Click
                          on the Add button. The selected table will
                          appear in the relationship window. After
                                                                                        Database Tools tab
                          adding  the desired tables, click on the
                          Close button to close  the  Show Table
                          dialog box.

                  Step 3  Click and hold on the Primary Key field of
                          one table.

                  Step 4  Drag the mouse pointer to the common
                          field  in  the  other  table  and  release  the
                          mouse button.  The  Edit  Relationships
                          dialog box will open.
                  Step 5  Click on the Create button.
                                                                                    Edit Relationships dialog box
                  This will create a line or relationship between the
                  related fields of the two tables:






                                                                                           The relationship
                                                                                           established between
                                                                                           'StudentsDetail' table
                                                                                           and 'StudentsMarks'
                                                                                           table based on the
                                                                                           Primary Key named
                                                                                           ‘Roll No’.


                                             Relationship Created





                 102     Touchpad iPRIME (Ver. 2.2)–VII
   99   100   101   102   103   104   105   106   107   108   109