D
Daoud Fakhry
All masters,
I know this is very basic question. I have searched alot but couldn't get
what I need. I have a table with the following info:
HolidayTable:
- ID
- Date
- Purpose of Holiday
- Type
I have another table named Overtime where I want to keep the employee
overtime records in details. One employee might work overtime on 5 different
holidays in a month and different hours in a holiday.
OvertimeTable:
- ID
- EmployeePIN
- Date
- Purpose of Holiday
- Type
- Hours Worked
I want to creat a form where I have a combo box selecting ID or EmployeePIN
and then I should have 5 more text boxes which preview the data based on the
selection of the combo box. My combo box should retriev data from
HolidayTable. there should be more than one combo box for different holidays
and hours worked as overtime. At the end I want to update the same
information I have selected from a combo box and the rest data displayed by
text boxes should be updated into overtime table for my later use. I need to
have a detailed information of which date an employee worked and how many
hours.
Is there any one to post me back on this regard. I appreciate your
cooperation in advance.
Thanks, Daoud Fakhry
I know this is very basic question. I have searched alot but couldn't get
what I need. I have a table with the following info:
HolidayTable:
- ID
- Date
- Purpose of Holiday
- Type
I have another table named Overtime where I want to keep the employee
overtime records in details. One employee might work overtime on 5 different
holidays in a month and different hours in a holiday.
OvertimeTable:
- ID
- EmployeePIN
- Date
- Purpose of Holiday
- Type
- Hours Worked
I want to creat a form where I have a combo box selecting ID or EmployeePIN
and then I should have 5 more text boxes which preview the data based on the
selection of the combo box. My combo box should retriev data from
HolidayTable. there should be more than one combo box for different holidays
and hours worked as overtime. At the end I want to update the same
information I have selected from a combo box and the rest data displayed by
text boxes should be updated into overtime table for my later use. I need to
have a detailed information of which date an employee worked and how many
hours.
Is there any one to post me back on this regard. I appreciate your
cooperation in advance.
Thanks, Daoud Fakhry