Page 256 - IT 402 v2.0 class 10
P. 256
Step 1: lick on the option reate iew from the ask . It opens with dd ables window.
Available Tables.
Step 2: Select the desired tables and click on the dd button. he selected tables will display the fields in
the respective table boxes.
3
Step 3: lick on the lose button.
Step 4: Now the relationship between the selected tables should be applied so that the records from both
the tables here in this example same customer id can be picked up and placed in a new table.
Step 5: o do so click on the rimary key field of the first selected table and then drag and release the mouse
button on to the rimary key field of the other table.
254 Touchpad Information Technology-X

