Using Access 2007, I'm trying to make a shiftregistration software.
As you can see underneath, I have a many to many relation between employees and dates. On each shift/date, I register any amount of employees as well as some time variables. Also on each shift I register some shift-specific notes.
I already made a form including a subform for this purpose - working well as of now. But I have a few concerns...
Here you can see the form containing subform wich displays the current employees registered on the choosen date. In the subform I am able to add and remove employees as well as register different time variables.
Each time I have a new shift, I will first have to go to the shifts list and create a new shift/date in order to be able to register employees or notes on that shift. I would much rather like to embed a calendar control, where I can click any date, even if it has been created in the shifts table or not - and when I add my first employee or start writing a note on that date, the shift is automatically added to the shifts table.
How is that possible?
Please let me know, if you need any additional information.