I have this problem that i can never ever figure it out how to start.
table_Holidays:
1. ID
2. Date
3. Holiday Type
4. Holiday Discription
table_Timesheets:
1. ID
2. Employee.ID (linked to table_Employees)
3. Work Date (to hold -when)
4. Hours Worked (to hold -how many hours worked on work date)
Now when i input the date that i have set to be holiday, i want it to be double pay. :banghead:
How do you do that?
table_Holidays:
1. ID
2. Date
3. Holiday Type
4. Holiday Discription
table_Timesheets:
1. ID
2. Employee.ID (linked to table_Employees)
3. Work Date (to hold -when)
4. Hours Worked (to hold -how many hours worked on work date)
Now when i input the date that i have set to be holiday, i want it to be double pay. :banghead:
How do you do that?