Trying to figure out whether using a dereference or creating an action to update one table from another table is better.
I have two tables,
Currently as an inspection takes place, [Date Inspected] and [Next Inspection] related to a specific [Equipment ID], columns are added to new inspection row, this happens for every new inspection and a row is added. However I want to also have these new dates for the relevant Equipment ID ie [Previous Inspection] and [Next Inspection], update and show in the Equipment table too.
Thus I can either create a dereference to the most recent inspection for that [Equipment ID] (not sure of a formula for this on the dereference formula input, it would need some sort of constraint for the most recent inspection/row for that specific Equipment ID). (might affect sync time)
Option 2, is to create a workflow update each time an inspection related to a particular [Equipment ID] takes place, it updates the [Previous Inspection] Date & [Next Inspection] date in the Equipment table for those two columns too. I prefer option 2.
However the issue I am experiencing, is that I have to create two actions for the workflow. The workflow,
any input or better way of doing this would be appreciated, thank in advance.