I’m quite new with SP so I apologise if I cant specific myself too effectively.
Downside at hand:
Two lists – Retailers and Managers with a many-to-many relationship between them.
I.E. in Retailers there will be multiple managers and a supervisor can handle multiple store
I wish to both:
- Create a Record C the place I’ve a lookup column itemizing every store within the first column and in one other ALL of the managers that correspond to this store, written in a single line.
- Insert a column in Retailers outlining all the managers per a selected store.
Basically I wish to create a workflow that’s activated on a particular date, which checks whether or not there was any change within the Managers or the Retailers record and subsequently replace Record C.
Any thought on how I can get a number of values for a lookup?
I created the workflow, however I can solely have one worth per a subject in Retailers for managers.