I am creating an overtime signup sheet database.
The supervisor would enter the date of overtime and the time span (will use drop down box for the 2 hour increments).
The employee's need to be able to look at the available overtime and signup for it if they want to work it.
After a span of time the supervisor needs to look at who signed up for each date and time slot deteremine who "wins" and flag that name as the winner as it were.
I am stuck on how to design the entry, signup, and approval part so they work together. They need to be able to remove their name from the signup if they change their mind but not effect everyone else that has signed up for it. And what process would be best to flag the winner out of the list of potentials?
What seemed like a simple project has proved to be frustrating to develop at least for this newbie.
The supervisor would enter the date of overtime and the time span (will use drop down box for the 2 hour increments).
The employee's need to be able to look at the available overtime and signup for it if they want to work it.
After a span of time the supervisor needs to look at who signed up for each date and time slot deteremine who "wins" and flag that name as the winner as it were.
I am stuck on how to design the entry, signup, and approval part so they work together. They need to be able to remove their name from the signup if they change their mind but not effect everyone else that has signed up for it. And what process would be best to flag the winner out of the list of potentials?
What seemed like a simple project has proved to be frustrating to develop at least for this newbie.
