I have a site with multiple lists which are linked to each other. When I update an item(edit / approve) in one list, the approval status of the corresponding items in the other lists also should be updated accordingly.
I was able to achieve it using an event receiver on
ItemUpdated event, and the item approval is reflected fine.
However, when I further edit an item in any list, the item of course goes into
pending status, and I am copying this moderation status to the other lists. But in doing so, the approved version in the other lists are lost; whereas the item in the source list still has an approved item.
This is causing an inconsistency for me because I have an approved item in one list, but not in the other lists. Because of this,
Viewers see the item in the 'source list', but when they try to check the other lists, they get an error.
How can I resolve this?