related field in different table

hi ,

if have two tables “demand” and “navatte” each on have his own “status”, i want when status → all status of demands related of that navette change dynamically.

i used “modified” method in navette form but in my case the status of navette change depanding of other fields so “modified” is not called only if i change the status manually.

thanks in advance