Can I Update Record with MultiList???
I have timecards set up in my database and they work great however, if we are paying holiday pay, etc. I have to create one for each employee just to enter the holiday time.
Is there anyway to have a form with a multi list box on one side the time card fields on the other so I can select multi (or all) employees, enter the date and 8 hours in the holday field and have it update all of them?
My tables are set up like this:
TIMECARD
TimeCardID
EmployeeID
WorkDate
TIMECARDHOURS
TimeCardDetailID
TimeCardID
WorkOrderID
RegHrs
OTHrs
VacHrs
HolidayHrs
BereavementHrs
OtherHrs
and of course I have the employees table?
Can this be done?
THANKS!
I have timecards set up in my database and they work great however, if we are paying holiday pay, etc. I have to create one for each employee just to enter the holiday time.
Is there anyway to have a form with a multi list box on one side the time card fields on the other so I can select multi (or all) employees, enter the date and 8 hours in the holday field and have it update all of them?
My tables are set up like this:
TIMECARD
TimeCardID
EmployeeID
WorkDate
TIMECARDHOURS
TimeCardDetailID
TimeCardID
WorkOrderID
RegHrs
OTHrs
VacHrs
HolidayHrs
BereavementHrs
OtherHrs
and of course I have the employees table?
Can this be done?
THANKS!