Creating and modifying table-to-table relationships

Prev Next
Table-to-table relationships in Quickbase help you organize the data in your app. If you have data that is common across what you need to track, a relationship lets you enter the data once and make references to it later, rather than entering it rep...
Access to this feature can change based on your Quickbase plan. Learn more about feature availability and plans in Quickbase capabilities . You can create a relationship between two tables within an app, or between two tables in separate...
You can enhance relationships between tables by adding additional fields, like lookup and summary fields. These fields can help users by showing them more information or letting them move back and forth between tables quickly and easily. Read A...
Once you've created a table-to-table relationship , you may find that the reference field doesn't show the information you want. For example, when you display a record or report, the field may show the Record ID#. You may want to show more meanin...
To perform calculations in your table, for example total orders based on specific criteria, use summary fields. Summary fields are part of table-to-table relationships. Stored in the parent table of a relationship, they summarize fields from related...
You may need to create a report that includes information from two different tables. First you create a table-to-table relationship between the tables, then to draw many values from the different tables together, you may need to enhance the relati...
A relationship between tables is usually one-to-many, where one record in the parent table relates to many records in the child table. For example, one project has many tasks. But what if you have a many-to-many scenario, such as students and clas...
A relationship between tables can involve many different fields . You can delete almost any field that is part of a relationship except a reference field. To delete a reference field, you must first delete the relationship itself. Then, within th...
Before you delete a relationship, understand that you'll lose any data you've entered in fields belonging to that relationship. Open the app that contains the relationship you want to delete. If you created a relationship between tables in two d...
To view all tables and relationships in a data model, you can use either the relationship diagram or Visual Builder . Use relationship diagram Note: This view is only available to roles with Full Administration access to the app. Open th...