Not sure if this is something that is possible, but thought I would ask anyway
I'm currently working on something for quality assurance, which allows users to log complaints that they receive. I have it set up with one SharePoint list that contains all entries (for QA to use to track all complaints) and then a separate list for each department which contains just their own complaints. I had to set these up as different lists as QA does not want each department to see anyone else's complaints, and as far as I can find there's no way to limit access to views.
I'm now trying to get it so that when one of the departments updates the status of their complaint, that change is then reflected in the main QA database. I found one solution that works, but it requires a new workflow for each department (currently 11, however could grow)
I was just wondering if there was any way for this to be contained in 1 workflow in the main QA list, that then pulls the data from the department lists. This doesn't have to be constant, and could just be ran periodically if that would be easier
Thank you in advance for any help anyone can give!