My row and headers look like this (Asignments Table):
Codigo|Tienda|Apertura|Cierre_20_00|Cierre_20_30|Cierre_21_00|Sanitarios|Barrer_Mat|Barrer_Vesp|Trapear_Mat|Trapear_Vesp|Limpiar_Ventanales_y_Vitrinas|Encargada|Supervisora
2 |1010 |2010 |0 |0 |2010 |3010 |3010 |2010 |2010 |3010 |3010 |2010 |1102
Each task besides Codigo, Encargada and Supervisora has a user code asigned to it. Now I need to export each instance for each task to another table where each task has specific timeframes to complete. as in table Tareas (Tasks):
Asignacion |Tiempo_Inicio |Tiempo_Limite |Empleado |Supervisor
Apertura |11:00:00 AM |11:10:00 AM | |
What code can I run after each Asignment capture is completed? I believe it has to be an UPDATE, but how to pick each Assignment from that row and export it to each Empleado Column under Tasks table on SUBMIT?