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. To do so:
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.)
In the table bar on any application page, click one table in the relationship.
Unless you've created a relationship across separate applications, this table can be either the master or the details table of the relationship.
Select Customize --tablename-- table > Relationships. Locate the relationship you want to enhance and click its Edit link.
QuickBase 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 field:
To add a Lookup field, click Add Lookup Field at the bottom of the Details Table box, select the field that you want to add from the drop-down list, and then click OK.
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 OK.
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.)
© 1999-2010 Intuit Inc. All rights reserved.