DDH Software, Inc Making a big world smaller

Relationship and subtotals example

Author:Shannon Simpson [Send Author Email]

August 13, 2003
Description:Example of using a running total in one database, and then seeing the results of a running total in a second database, through a Relationship field, with the running total applying only to the related records. Install both files in the zip file to your handheld, and then open "relate1" to see how the relationship field is set up. Open "relate2" to see how the calculated field is set up. The Relationship field in "relate1" shows the value of the calculated field in the last related record from "relate2". Sometimes, you will need to force a recalculation for just the related records. One way to do this is to open the record you want to look at in "relate1". Then, use the Relationship button, to see the related records. To force a recalculation taking only the visible records into account, tap on the field name "calc", and use the option "set value to". Then tap OK, and that will force a recalculation of the records taking only the related records into account.
Has Data:Yes
Has Forms:No
Version:HanDBase v.3.0x or greater
File:relatesample.zip          Downloads: This Month 9 / Total* 1654
Note:MAC Users will need to enter the filename relatesample.zip when saving this file.
* since October 1, 2000.

Other Titles from Shannon Simpson