I have a table with store scorecards where a mystery shopper grades a retail location. They do this by looking at past camera footage. They enter the date/time of the footage they are using as a basis for the scorecard along with scorecard attributes...

We have 20 retail locations and I am creating a simple task system. There are times when we need to create a task and then assign out that same task to every location. I have a table for tasks and one of the columns is Location. When I create a task ...