software

Tutorial 6

Split Joined Tables to show in seperate grids

Thu, 02/11/2010 – 21:46 — NuVu Support Team

This tutorial assumes you have the knowledge gained from working with the previous tutorials. After this tutorial you will have the ability to display tables selected in any query on separate grids (up to 3 grids are allowed, although multiple tables can be shown in any one grid).

Perform the following steps:

  • If the Query Designer Tool is already running, please close it down. Invoke the NuVu Query Designer from the NuVu Query program group from the windows Start menu. The main NuVu Query Designer window will be displayed, and a welcome dialog window will also be displayed that shows recently saved/opened queries. We are going to create a new query from the previous query (tutorial5), so double-click on the ‘tutorial5′ item that should be displayed inside the Welcome dialog window (if you have successfully performed the previous tutorial and saved it as specified in that tutorial with a name of ‘tutorial6′). The original query will open inside the Designer. We need to now save this as ‘tutorial6′ before we start working with the query, so click on the File->Save As menu item and advise a new Query name of tutorial6 when the save properties are displayed.Click the  button to save the query with the new advised name.
  • Click the  (Join Properties) button on the toolbar to invoke the Join dialog window. The window shows a list of Child/Parent table joins, as well as other information regarding each join (the fields on which the join will be achieved, index to use etc.). In the case of the current query, there are only 2 tables that are joined (the Order table (child) joined to the Customer table (parent)).
  • Tick the Show results in separate grid box, as shown below:
  • Click the  button. The main Query window will now be displayed, and you will see that there are now two grids displayed, being the Customertable in the first grid and the Order table in the second grid.
  • Click the  button to start execution of the query. A dialog window will appear briefly indicating the various steps that are being performed. Once the query results have been retrieved, this dialog window will disappear and the results will be shown inside the grid on the designer window, as shown below:
  • Note the new query will show the customer information on the top grid and the order information relating only to the highlighted customer on the bottom grid. Experiment by selecting different customers in the top grid to see the results shown in the second grid.
    Also note that you can adjust the height of the second grid by hovering the mouse between the two grids until the mouse pointer changes to a resize pointer and then hold down the left mouse button and drag the mouse in the required direction (upwards or downwards).
  • Finally we will save the changes made to this query (as this will form the base query for the next tutorial), so simply click the  button and close down the query tool.

We are complete with the tutorial. An exported query containing this tutorial is available by right-clicking here and choosing Save Link As (Firefox) or Save Target As (Internet Explorer) to save the query import format file to a file on your hard disk, and then importing that query into the query tool (hint: choose File->Import Query from the main menu of the Query Designer).

End of Tutorial