Modified_Time is not updated in the case of bidirectional relationship lookup fields
"Enable bidirectional relationship" option in lookup fields is a great feature, but I think that there is still a problem related to it. Let me start with an example:
I have a form named Participants and another one Workshops. In the Participants form I have a lookup field named ChooseWorkshop - which refer to a field WorkshopName in Workshops form. I enabled the bidirectional relation in the ChooseWorkshop field, so a lookup field WorkshopParticipants is created in Workshop form.
The WorkshopParticipants field for workshop X record is updated whenever a new participants chooses workshop X... so the record of Wokshop X changes, because one of its fields changes. I would expect that Modified_Time built in field to to be automatically updated after this change which happens automatically, but it is not the case. And I think that this is the problem. When a script modifies a record in any way, Modified_Time is updated, but in this case we have an exception, and this limits the functionality of this feature. Also, I suppose that Modified_User and Modified_User_IP_Address should be also automatically updated .
It would be great that be able to use formula fields - for example to automatically count the participants number for each workshop - but in the actual situation if Modified_Time is not automatically updated whenever WorkshopParticipants is changed, the value of the formula field is also not updated.
Regards,
George