Error updating record in bounded form

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

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.

Quote:

---

Originally Posted by 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.

---

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