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
   251   252   253   254   255   256   257   258   259   260   261