I am currently working on SharePoint 2016 on premises,
I have a situation where in the root site, I have a list A which has a content type X and one of the fields is counter (starts with 1). From a sub-site there is another list B, which has a lookup to List A, when a user creates an item on list B the counter related to the item in List A should be updated. I am trying to see the different options I have. The problem is I cannot use provider hosted apps since it is against policies so no event receivers can be created via server side code.
I was thinking of doing this via workflow via SPD, can anyone tell me if this is a good idea, and if yes provide me with some knowledge on this since I have never done any workflows before.