You can greatly enhance relationships between tables by adding additional fields, like lookup and summary fields. These fields can help viewers by showing them more information or letting them move back and forth between tables quickly and easily. Read about relationships to learn more about these field types. You can add one of these fields at any time.
Open the application which contains the relationship you want to enhance with additional fields.
If you've created a relationship between tables in two different applications, open the application that contains the details table. (Don't know what this is? Read about relationships.)
Click the table name in the table bar of your app.
Click SETTINGS in the page bar, then click Table to table relationships under Table Structure on the Settings page.
Click the relationship that you want to edit.
Quick Base displays the Relationship Properties page, which lists fields that comprise the relationship. The left side of the page shows fields in the Master table and the right side of the page, displays fields from your details table. To learn more about what each of these fields can do to enhance your application, click a field name below, or read About Relationships.
Add the fields:
To add a Lookup field, click Add Lookup Fields at the bottom of the Details Table box, select the field that you want to add from the dropdown, and then click Create.
To add a Summary field, click Add Summary Field at the bottom of the Master Table box, select the function (count of related records, totaling a particular field in the details table, etc.) and then click Create.
To add a Report Link field, click Create Report Link at the bottom of the Master Table box. (If your master table already contains a Report Link field, you won't see this button.)
To add a URL (formula) field, click Create "Add Record" (where Record is replaced by the term you use to refer to records in the table) at the bottom of the Master Table box. (If your master table already contains a URL field, you won't see this button.)
When you have finished adding fields, click Done in the page bar.
© 1999-2018 QuickBase, Inc. All rights reserved. Legal Notices.