Page 44 - Touchpad_Plus_V3.2_Class 8
P. 44
Tools menu
Step 2 Select the table and click on the Add button. The
selected table will appear in the Relation Design
window. Repeat clicking Add button to add more
tables in the Relation Design window. When all the
required tables have been added, click on the Close
button.
Step 3 Press and hold the left mouse button on the Primary
Add table
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 create a line or relationship between the
related fields of the two tables.
Relationship established between Student table and
Fee table based on the field named ‘Roll No’.
Creating a Query Relationship Created
To create a query, follow these steps:
Step 1 Click on the Queries button in Database pane.
Step 2 Click on the Create Query in Design View option in Tasks pane. The Add Table or
Query dialog box will open.
Step 3 Select the tables to be added and click on the Add button.
Creating a query Add Table or Query
dialog box
42 Plus (Ver. 3.2)-VIII

