Page 104 - Trackpad_ipro 4.1_Class7
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 Create tab.  2  Click on the Query Design command.













                                    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     iPro (Ver. 4.1)-VII
   99   100   101   102   103   104   105   106   107   108   109