I have 9 custom lists for 9 departments data and i have a custome list for a Consolidated tracker of all the departments in the same Site.
When i circulate the links each department will be adding items to their department's list.
My Requirement is, when a new item is added or when the existing item is edited and the same should be added/modified in the Consolidated list as well.
How to create this dependency?
I cant use lookup as all the custom list contains the same columns as in the Consolidated list.
Please help me out in achieving this
Can i achieve this by defining a Term Set with MMS?