Viewing All Tables and Relationships

How many times have you wanted a picture that showed how all the tables in your app were related?

To view all tables and relationships in an app:

Note: This view is only available to roles with Full Administration access to the app.

  1. From the app home page, click .

  2. Under Advanced Features, click App management.

  3. Expand the Show App Info section, if necessary.

  4. Click Show relationship diagram.

    Each table in the app is shown here with its icon, and relationships to and from that table are shown as arrows. The reference field for the relationship is shown on the arrow.

Tip: For those of you who would like to put this view on an app home page (for example), the URL to display the diagram looks like https://target_domain/db/app_dbid?a=reldiagram. Substitute your Quick Base domain name for target_domain, and the app identifier for app_dbid.

To rearrange the diagram:

Click and drag a table in the diagram to move it to a different place on the page. Once you have rearranged the diagram to your liking, click Save this layout. If you return to the relationship diagram for this app, it will display as you have saved it. If you don't like the layout, click Clear saved layout and refresh the page.

To show information for a table:
To show information for a relationship:

Hover your mouse over the reference field. Information about the relationship displays.

To show or hide parts of the diagram:

If you have large numbers of tables or relationships in your app, you may want to hide parts of the diagram in order to better understand it.

 

Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.