Page 55 - TP_Prime_V2.2_Class8
P. 55
To create a relationship, create two tables:
• Table named ‘StudentsDetail’ that holds general information about the students such as
their Roll No, Student's Name, Father’s Name and Class.
• Table named ‘StudentsMarks’ that holds information about Roll No, Marks and Percentage.
Using Tables for Defining Relationships MORE ON ACCESS
To define relationship between the two tables, follow these steps:
Step 1: Click on the Relationships command
from Relationships group under
Database Tools tab. 53
Step 2: The Show Table dialog box will open.
Click on the Add button. The selected
table will appear in the relationship Database Tools tab
window. After 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. This will
open Edit Relationships dialog box.
Edit Relationships Dialog Box
Step 5: Click on the Create button.
This will create a line or relationship between the related fields of the two tables:
Relationship established between
'StudentsDetail' table and 'StudentsMarks'
table based on the Primary Key named ‘Roll No’.
Relationship Created

