I have two tables: Project activities, which is my master table, and Activity status, which is a child table.
I have an automatic status, which depends on the dates of the activity and which is defined in Project activity table. I have another status that is defined by project managers manually in Activity status table. I need to have a history of status change, therefore I created reversed relationships between two tables and I display only the latest manual status on master table. How can I also "fix" automatic status in the child table, so I can see the comparison in the status history log?