B
beefyme
Hi there
Im making a staff rota planner, and i have a table called Staff_Shift and
another called StaffAvailability. The field StaffID in the staff_shift table
is based on a query from staffavailability and so provides a dropdown for the
staff that are available to work.
When i open the form staff_shift the default search criteria is Monday (to
see who can work on monday.) This works fine, and a dropdown is provided on
who can work this day.
However if i change the criteria on the Staff_shift form to a different day,
when i click on the StaffID field to see what staff are available i get the
error:
"The record cannot be deleted or changed because tblStaff_Shift includes
related records"
I dont understand why im getting this error!
Any ideas? I really need help with this!
I can send you the file if you can help.
Thanks
Im making a staff rota planner, and i have a table called Staff_Shift and
another called StaffAvailability. The field StaffID in the staff_shift table
is based on a query from staffavailability and so provides a dropdown for the
staff that are available to work.
When i open the form staff_shift the default search criteria is Monday (to
see who can work on monday.) This works fine, and a dropdown is provided on
who can work this day.
However if i change the criteria on the Staff_shift form to a different day,
when i click on the StaffID field to see what staff are available i get the
error:
"The record cannot be deleted or changed because tblStaff_Shift includes
related records"
I dont understand why im getting this error!
Any ideas? I really need help with this!
I can send you the file if you can help.
Thanks