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. Available display types are Accordion, Tabs, or Titles. Repeat the process to add multiple relationships.

Multi-Level Relationships #

The App Builder supports 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.

Notes #

• Detailed instructions are available in the wizard
• Deselect only columns containing sensitive data that should not be visible to the user (columns containing non sensitive data can be hidden in the Table Builder and Form Builder allowing to e.g. access these values in computed field)
• Relationships can be established with both local and remote databases
• The base table and related tables can be stored in different databases
• For m:m relationships, the join table must be in the same database as the relation table
• If the structure of a table changes, click the refresh icon button to apply the new structure