Storing Multiple Days of the Week in a Yes/No Format

[TheMachine]

I'm relatively new to MS Access--more used to working with an actual server like MSSQL, but I've been given a job in Access 2007 for employee management. I already have the employees table all set up for the most part with a basic form, however, I'm trying to add a key feature. Each employee works a variable number of days and hours, so I need to link these up. My first problem arises from how to actually implement this feature. Does anyone know what the best solution to storing this value per-employee would be? The only thing I can think of is having a separate "Days of the WeeK" table with an ID linked up to the ID of the employees. Would this work? If so, how would one go about linking that up to checkboxes on a form? Thanks for any help!



A note about the per-employee days of the week storage: the complicated part--to me--is that each employee could have two schedules, which means that I need two identical sets of this per-employee. So each employee would have up to two entries into the days of the week table, which (could?) cause problems if I just linked the IDs, right?

[orange]

I would not recommend a Days_Per_week approach.

I would try to write a few sentences of exactly the business process is, before trying to get the implementation figured out.
It's always best to determine WHAT is required before getting into the HOW.
Good luck with your project.

[TheMachine]

Thanks orange. Would you have a better idea for storing an employee's schedule in a database using Access? In the past I have worked with software I write myself, so the end-user will never see the raw data. Usually what I did was serialize an array and I had enumerations in the software for days of the week which I could easily reconstruct with a few lines of C++. I'm not exactly sure this is even possible in Access--especially tied to a series of check boxes on a form.