The following relationship types are supported

• One-to-one relationship (1:1)
• One-to-many relationship (1:m)
• Many-to-many relationship (m:m)

Adding Relationships #

Relationships can be added using the Table Builder or Form Builder

• Create an app
• Edit a row
• Open the Table Builder or Form Builder
• Access the relationship wizard from the Table or Form menu under Relationships

The Relationship Wizard #

To add a relationship, click the “Start Relationship Wizard” button and follow the instructions. Relationships are added to the bottom of the form. Use the display type to define how relationships are shown. The options are Accordion, Tabs, or Titles.

Read more…

Multi-Level Relationships #

You can build multi-level relationships (e.g., grandparent-parent-child-grandchild). The Table Builder and Form Builder for the master table are accessible directly from the app toolbar. The Table Builder and Form Builder for detail tables are available from the table footer or form footer, respectively.

To add a relationship to a detail table

• Open the detail table
• Open the Table Builder or Form Builder for the detail table (button available from the footer)
• Go to the Relationships section and start the Relationship Wizard

There is no restriction on the number of relationship levels, but keep in mind that a high number of levels requires more resources and can negatively impact performance, especially for users with low-capacity computers.