I need some help creating some new tables in my existing staff database.
Each employee will have:
1. Start Date
2. End Date
3. Activity for that period
What I need is to be able to track where each person is throughout the year.
I’m thinking what I need is a Usage table and a Need table.
When a user selects a certain date range, I need to be able to check and see if that person is already scheduled to do something on that day or for that date range.
Let’s say a person is scheduled from 1/1/05 until 3/10/05 to do programming. When a user comes in and selects the same person to do programming from 2/5/05 until 4/5/05, I will need it to say that this person is not available for this set of dates.
Is this something that is doable? Can I actually compare dates and account for vacation, sick days, etc.
Any help, ideas, examples (possibly) would be greatly appreciated.
Thank you.
Each employee will have:
1. Start Date
2. End Date
3. Activity for that period
What I need is to be able to track where each person is throughout the year.
I’m thinking what I need is a Usage table and a Need table.
When a user selects a certain date range, I need to be able to check and see if that person is already scheduled to do something on that day or for that date range.
Let’s say a person is scheduled from 1/1/05 until 3/10/05 to do programming. When a user comes in and selects the same person to do programming from 2/5/05 until 4/5/05, I will need it to say that this person is not available for this set of dates.
Is this something that is doable? Can I actually compare dates and account for vacation, sick days, etc.
Any help, ideas, examples (possibly) would be greatly appreciated.
Thank you.
