Compartir a través de

How to: Find Related Data

  • Artículo

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

In Microsoft code name “Quadrant” you can trace connections between records. This topic shows how to double-click records from a workpad to view related records. The topic uses sample data is installed in How to: Install the "Quadrant" Sample Data.

An easy way to find related data is to view a collection or record by using a tree viewer. In a tree view, expanding the nodes of the tree can lead to references to other records, or collections of records.

To find a person's tasks

  1. If you have not connected to the Repository database before, use the steps outlined in How to: Connect to a SQL Server Database with "Quadrant" to connect to the Repository database.

  2. If you have connected to the Repository database before, on the View menu, click Explorer, and then click Repository.

  3. Expand the Database node.

  4. Expand the Microsoft.Samples.Organization node.

  5. Double-click the People node. The new workpad titled People shows all records in the People table.

  6. Double-click the icon for the Kim row. A new workpad named Akers, Kim opens.

  7. In the upper-right corner of the Akers, Kim workpad, click the viewer switch icon (the triangle) and select Tree Master/Detail.

  8. Expand the Business Analyst (1) and the Akers, Kim node. Click the Tasks subnode. Note that all the tasks that belong to the person are displayed in a table viewer in the right pane.

By double-clicking icons in a workpad, you can discover the relationships between different records.

  1. Return to the Akers, Kim workpad.

  2. In the upper-right corner of the Akers, Kim workpad, click the viewer switch icon (the triangle) and select People Properties (Default) to view the record in properties view.

  3. Double-click the Current Events icon under the Responsibilities header.

    A new workpad opens, displaying the complete set of events that belongs to the person in a table viewer.

See Also

Tasks

How to: Use the Explorer to Examine Databases
How to: Use Queries in "Quadrant"
How to: Use Viewers in "Quadrant"