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

Related Content

Nesting API Button Help (Add record and update another)

Moving Fields from One Table to Another

Copy Single Table from One App to Another

Updating $$ amounts

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