Create a Parent-Child Relationship


Note:
  • You must be an Organization Administrator and have the database editor feature.
  • A database table can have many child tables related to it.
  • A database table can have only one parent table related to it.
  • Only parent tables can be hosted on GroveSite Web Pages.

Create Table Relationship - Database Manager

Create a table relationship from the Database Manager

Picture Create Table Relationship - Database Manager


Create Table Relationship - Table Editor

Create a table relationship from the Database Table Editor

Picture Create Table Relationship - Table Editor


Create Table Relationship - Step 1

Select the second table you wish to relate to the initial table.

Picture Create Table Relationship - Step 1


Create Table Relationship - Step 2

Determine the relationship between the tables.

Answer the question: "For this relationship, which of the following statements is true?"

Picture Create Table Relationship - Step 2


Create Table Relationship - Step 3

Confirm your choices and save the relationship.

Picture Create Table Relationship - Step 3


View the Parent-Child Relationship

After confirming and saving the database tables' relationship, you may view the relationship in a few different places. In a database table editor page, you may see the table relationships, if any exist.

On the Manage Database page, you may view the parent-children or the child-parent database table relationship.

Picture Create Table Relationship - View