Database Toolbox

Relational Display of Data

1. After executing a query, select Data from the Display menu.

The query results appear in a figure window.



The display shows only the unique values for each field. For example, there are 10 entries in the StockNumber field, 8 entries in the January and February fields, and 10 entries in the March field, corresponding to the number of unique values in those fields. Therefore, do not read each row of the table as a single record.

2. Click a value in the display, for example StockNumber 400876, to see the associated values.

The data associated with the selected value is shown in bold and connected via a dotted line. For example, sales for item 400876 are 3000 in January, 2400 in February, and 1500 in March.



As another example, click 3000 in the January field. There are three different items with sales of 3000 units in January, 400314, 400876, and 400999.

3. Because the display is presented in a MATLAB figure window, you can use some MATLAB figure functions. For example, you can print the figure and annotate it. For more information, use the Figure window's Help menu.
4. If the search results include many entries, the display might not effectively show all of them. You can stretch the window to make it larger, narrow the search so there are fewer results, or use Report Display of Results in a Table.

Viewing Query Results

Chart Display of Results