I have a table called Scheduled Vacation that basically tries to keep track of the vacation that an employee requests. I have a form that I use to enter the data. The form has the following fields:
Sch Ind which is an autogenerated number for the primary key
Empl ID
Date
Total Hours Scheduled
Classification
The table Scheduled Vacation has the same fields plus one more:
Sch Ind which is an autogenerated number for the primary key
Empl ID
Date
Total Hours Scheduled
Classification
Supervisor ID
The idea is to be able to tell who is on vacation for any given time frame whether partial day or whole day within what classification, and for which supervisor.
The idea is that I should be able to enter the employees Empl ID # and the Classification field and Supervisor ID should automatically update with the Name of their classification and the Name of the Supervisor respectively. I have another table called Employees that has the following fields:
Employee ID
First Name
Last Name
Classification ID(which is the ID number associated with that person's Classification)
Seniority Date
Supervisor ID
I have yet another table that lists the actual text name associated with the Classification ID called Classification List and it has two fields:
Classification ID
Job Classification
I have yet another table that lists the actual text name associated with the Supervisor ID called Supervisors and it has three fields:
Supervisor ID
LastName
Title
Also it would be great if (I don't know if this is possible on this form) after the person enters the empl id and the classification is updated and the date is entered a message could come up if there are more than the allowable limits of people in that classification off that same day. 10% during storm season and 25% all other times.
I hope that this makes sense and I hope that someone can help me.
Thanks
Sch Ind which is an autogenerated number for the primary key
Empl ID
Date
Total Hours Scheduled
Classification
The table Scheduled Vacation has the same fields plus one more:
Sch Ind which is an autogenerated number for the primary key
Empl ID
Date
Total Hours Scheduled
Classification
Supervisor ID
The idea is to be able to tell who is on vacation for any given time frame whether partial day or whole day within what classification, and for which supervisor.
The idea is that I should be able to enter the employees Empl ID # and the Classification field and Supervisor ID should automatically update with the Name of their classification and the Name of the Supervisor respectively. I have another table called Employees that has the following fields:
Employee ID
First Name
Last Name
Classification ID(which is the ID number associated with that person's Classification)
Seniority Date
Supervisor ID
I have yet another table that lists the actual text name associated with the Classification ID called Classification List and it has two fields:
Classification ID
Job Classification
I have yet another table that lists the actual text name associated with the Supervisor ID called Supervisors and it has three fields:
Supervisor ID
LastName
Title
Also it would be great if (I don't know if this is possible on this form) after the person enters the empl id and the classification is updated and the date is entered a message could come up if there are more than the allowable limits of people in that classification off that same day. 10% during storm season and 25% all other times.
I hope that this makes sense and I hope that someone can help me.
Thanks