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

