Page 104 - iPlus_Ver_2.0_class_7
P. 104

5  Drag and drop the Primary Key field of one
                          table to the common field in the another table.         6  Click on the Create button.















                  This will create a line or relationship between 'StudentsDetail' table and 'StudentsMarks' table
                  based on the Primary Key named ‘Roll No’.











                                                                                           Relationship
                                                                                           established.





                  Creating a Query


                  To create a query, follow the given steps:

                             1  Click on the    2  Click on the Query Design command.
                            Create tab.












                              3  Select the desired table and click on the Add button.














                       4  Double click to add the field's name to the query window.    5  Specify the criteria.





                   102
                         iPlus (Ver. 2.0)-VII
   99   100   101   102   103   104   105   106   107   108   109