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

