Updating Status from one table to another

Question

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.&nbsp; How can I do this?

robertvalentine · Answer

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".

mcfneil · Answer

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.

Forum Discussion

Updating Status from one table to another

2 Replies

Related Content

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Update Delivery Status based on Tracking Number for Fedex

Change a record in one table when another table's record updates

Question about Last updated by

Status Field Based on Contract Status

Recent Discussions

Save & Redirect in a Formula URL Using API_GenAddRecordForm

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API