Calculated field in child refresh if parent record is updated

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
rpierce
Veteran Member
Posts: 255
Joined: 2018-11-26 13:55
Location: Washington State

Calculated field in child refresh if parent record is updated

Post by rpierce » 2022-12-13 00:47

Hello,

Is there a way to cause the calculated field in a child record to recalculate whenever the parent record is updated? The code below works fine when creating a new record. However if the 'meetings' table is updated the calculated field (`trnhrs`) in the`discuss` table does not update unless you open the record and save it again. Any help is appreciated.

Ray

Code: Select all

SELECT ROUND(`meetings`.`head_ct` * `mins`/60,2)
FROM `discuss`
LEFT JOIN `meetings` ON `meetings`.`meet_id`=`discuss`.`meetid`
WHERE `discuss`.`discuss_id`='%ID%'

Post Reply