Use the XML Editor to create hierarchical or inheritance relationships between views. You cannot create a relationship between an XML source and a non-XML source.
To create a relationship between XML views:
Right-click the top of the child XML view in the workspace.
Select Create Relationship.
Move the pointer to the parent view to establish a relationship.
As you move the pointer, a link appears between the views, and the XML Editor verifies that the relationship is valid. If a relationship is not valid, an error message appears in the status bar.
If no error message appears, click the parent view to establish the relationship.
The XML Editor creates the relationship and adds the appropriate foreign key.
To view details about the relationship, place the cursor over the link between the views.
The Editor displays the relationship type and the primary and foreign keys.