Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Click on the Execute (run) the current query icon Image Modified from the toolbar.

...


  1. Alternatively, from the toolbar select the Query menu and then choose the Execute command, or use this command's accelerator keys (Ctrl + E).

    Image Modified

...


  1. In the Results window, select the first department: 100/Accounting.

...


  1. To execute the linked query, select the Results menu and choose the Linked Queries command. This will display a drop down menu.

...


  1. Alternatively, right mouse-click on the selected item and choose the Linked Queries command.

...


  1. Select the xEmployee by xDepartment and xEmployID command from the drop down menu. This will execute the secondary query using the department 100/Accounting as its selection criteria.

    Image Modified

...


  1. A new Results window is displayed to show you the list of departments.

...


  1. In the Results window, select an Employee.

...


  1. To execute the linked query, select the Results menu and choose the Linked Queries command. This will display a drop down menu.

...


  1. Alternatively, right mouse-click on the selected item and choose the Linked Queries command.

...


  1. Select the Notes by Employee command from the drop down menu. This will execute the linked query using the Employee as its selection criteria.

    Image Modified

...


  1. Cascade or Tile your windows to see all Results windows.

...

  1. Tip

...

  1. Hint: Select the Window menu to find these options.


    Image Modified

...


  1. Try a few more drill down paths for the same department, or start with another department.

...


  1. Close the query and result windows without saving.

    Image Modified

...


  1. Do not disconnect from this host.