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 form 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 (from staffID
field) is provided on who can work this day from the staffavailability table..
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 PLEASE HELP! Im pulling my hair out over this!
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 form 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 (from staffID
field) is provided on who can work this day from the staffavailability table..
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 PLEASE HELP! Im pulling my hair out over this!