In this task you will create a query with four Item Types showing the relationships between the parent (Instrument) and its siblings (Loop, Line, and Document).
-
Open the Reference Explorer and locate the Query Builder folder in the Queries folder.
-
Right-click the Query Builder folder and from the shortcut menu click New > Query.
-
On the Query Properties (New) dialog box, in the Name field type Instrument relationship, and check the Suppress Repeating Values check box (this removes any duplicate rows from your query results). If you want you can also add an explanation of what this query does in the Description field.
-
Click OK, the Query Builder opens.