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.
