Creating relationships between parent and child tables

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.

1. Use the List tab to select the table for which you want to create a relationship, and then click the Relationships tab.
2. Click New Row.
3. In the Relationship field, specify a name.
4. Create a WHERE clause.
5. Select a Child Object.
6. Optional: Type comments in the Remarks field.
7. 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.