Updating Status from one table to another

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have a One to Many relationship (one Work Order to Many Site Visits)
I need the status of the "most current" Visit to Change the status of the Work Order.  How can I do this?
Photo of Carla


  • 170 Points 100 badge 2x thumb
  • frustrated

Posted 1 year ago

  • 0
  • 1


  • 212 Points 100 badge 2x thumb
I would create a simple action that just says when a "Site Visit" record is added, modify the related record and copy the value from the "Status" field in "Site Visits" to the "Status" field in "Work Order".
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
You would need to make a "Report Link" field on the Site Visit table that uses the 'Related Work Order' as the connection.

(Basically making a fake reverse relationship).

Then you will be able to edit the parent Work Order when a Site visit is added.