Error updating record in bounded form

[tony007]

Hi guys I am creating maintenance form to update and add new records to department table.
But when I try to edit department field in employee table.
(I get the following error.I get same when try to add new record.)


http://i5.photobucket.com/albums/y18...department.jpg
==> pic of error errroupdatingdepartment

http://i5.photobucket.com/albums/y18...letionship.jpg
===> timekeepingreletionship


I be happy if some expert help me how to update and add new record to department table successfully without the above error and without changing the db structure.
Thanks

[RobDog888]

I'm no DB expert but your db schema doesnt look right. You dont need Hours Worked or Week tables. A single table for Time_Worked
or such should do it. The error is coming from referential integrity. Your trying to add a record in one table that depends on another record
existing in another table. Since it doesnt exist you get the error.

[tony007]

I'm no DB expert but your db schema doesnt look right. You dont need Hours Worked or Week tables. A single table for Time_Worked
or such should do it. The error is coming from referential integrity. Your trying to add a record in one table that depends on another record
existing in another table. Since it doesnt exist you get the error.

Thank u for u reply. is there a way to edit both employee and department tables in the same form at the same time. I be happy if u show me how to do over come this problem without trying to change the db schema.Thanks