I have two lists that both have "Compliance' and 'Status' columns. The List 1 columns are updated by a SP designer workflow every time a new InfoPath form associated with that list is uploaded.
Is there a way to automatically update the corresponding 'Compliance' and 'Status' columns in List 2 with the data updated in List 1 every time it is updated?
I would like the data in the two columns in List 2 to always match the data in the two corresponding columns in List 1, based on a unique valve (Asset No), in both lists?