I have a .qvw which the user selects a start date to work and enddate to work for that week-using variables.(vStartDate -vEndDate for the week) They are being written to an excel file, using input boxes./calendars.
Each day worked can have either an am ; pm ; eve shift they can work, for that day. One employee could work am and pm for the day or even all 3, or even just one shift.
The work week is from Monday to Saturday-so could be 6 days.
How could I got about dynamically giving the user an option to select a shift for each day selected. ?
eg. 26/11/2011 - am and pm
27/11/2011- pm and eve
28/11/2011 - am
Potentially there could be lots of shifts for each employee each week.