This content has been marked as final. Show 2 replies
You need to create another occurrence of the table in the Relationships Graph and link the two Table Occurrences.
To link a table to itself:
- Open Manage | Database | Relationships
- Click on the table occurrence for that table (The box with the same table name in most cases.)
- Click the button with two green plus signs
- This creates a new table occurrence of the same data source table. You can link them like you would any other pair of table occurrences, drag from a field name in one to a field name in the other.
For more on table ocurrences and how to use them: Tutorial: What are Table Occurrences?