So I have a work schedule and I'm looking to be able to press a button and it assign the locations from my locations table to each day so when a new day is created the locations are auto populated with those locations.
I have an assignments table which contains location id and the date and i would want a button or script that would run creating records for locationID 1 to the 1/1/2018 then locationID 2 to the 1/1/2018 etc up to how many locations i have then would do locationID 1 to the 2/1/2018 etc etc. for however many days you wanted to create.
Is this possible and how would you go about it.
any help is much appreciated.