Is there a way to change a field on a list if an item is modified on another list in the same site collection? For example, if a choice is made to a row on List A, a field in List B will be set to a specific value. More specifically, If set a status field to pending in one list, a status field in another list will be set to 'in queue' or something like that.
I believe I know how to query the list in order to find the entry I need to update, but I cannot seem to find out how to alter a specific value in that list entry.
Any help is greatly appreciated! Thank you!