Versions Compared

Key

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

...

  1. Click on the Execute (run) the current query icon

...

  1. Image Added 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).

...


  1. Image Added

...


  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.

...


  1. Image Added

...


  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.

...


  1. Image Added

...


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

...

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

...


  1. Image Added

...


  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.

...


  1. Image Added

...


  1. Do not disconnect from this host.