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%'