To retrieve data on objects, you must define the relationships
between objects. You define SQL for joins to create relationships
between parent and child objects.
Before you begin
Before you create a relationship, review the relationships
defined in the database to determine if you can reuse an existing
relationship. If the definition of a relationship does not match your
needs, do not modify the relationship. Instead, create an additional
relationship.
About this task
You define SQL for
JOINS. A JOIN lets you link
together data from multiple tables.
Procedure
- Use the List tab to select the table
for which you want to create a relationship, and then click the Relationships tab.
- Click New Row.
- In the Relationship field, specify
a name.
- Create a WHERE clause.
- Select a Child Object.
- Optional: Type comments in the Remarks field.
- Click Save Object.
What to do next
If the relationship that you created is for a table or attribute,
the changes will not take effect until you configure the database.