relationship

Syndicate content

The reference field (aka record-picker field) in the details table when displayed read-only always displays the value of the key field in the corresponding master record. The key field in the case you cite above is the Record ID#.

February 5th, 2009 - 5:02 PM

Let's assume that you have a District table, a Contacts table and an Orders table. The District table is the master table to the Contacts table and the Contacts table is the master table to the Orders table.

February 5th, 2009 - 5:02 PM

In QuickBase we call what you refer to as a dependency, a relationship. A relationship always involves two tables.

In the example above one of the tables would be a table of users. The users table would have a field for email address and a field for phone number. The users table, in this relationship, is the master table.

February 5th, 2009 - 5:02 PM

In the July 2011 release, we introduced a QuickBase feature called Copy Master and Detail Records. Use this feature to add a button to a master table that either copies the master record with its detail records, or imports a set of detail records into a different master record. QuickBase maintains relationships and dependencies when copying or importing the records.

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit