I’ve got one “parent” Projects table which has “children” Timesheets table.
I want to have the sum of a price column in my children table updated in real time in a price column of my parent table.
Whatever formula I wrote in parent column like :
- SUM([Related timesheets][Cost])
- SUM(SELECT([Related timesheets][Cost],TRUE))
I need to edit the project parent then save it to have the price column updated when I add or edit a timesheet child.
Is it the normal behaviour ? If so, then how automatically update the parent column ?
Or is it a bug, again ?
Thanks for your help