I have 2 departmental solutions. When a record reaches a specific status in the 1st department solution it creates a record in the 2nd department solution using an automation to create the record copying certain field values to the 2nd solution. It cannot be a lookup as the second department may need to edit the field data. It is possible that either department could make changes to this field that should be reflected in the other departments' solution. If I simply do an automation on field change on the field in both solutions I think I will end up in a loop. I thought about having a lookup field for the value in both tables and evaluate if look-up field is different from the editable field, this could create many extra fields. If only the lookup field had an option you could turn on to allow editing of look-up source field. That would be pretty great!
Any other ideas on how to solve this issue?