Updating Status from one table to another

  • 0
  • 1
  • Question
  • Updated 7 months 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

Carla

  • 150 Points 100 badge 2x thumb
  • frustrated

Posted 7 months ago

  • 0
  • 1
Photo of ROBERT VALENTINE

ROBERT VALENTINE

  • 152 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".
(Edited)
Photo of Matthew Neil

Matthew Neil

  • 31,418 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.