The conflict occurred in database

Question

hello friends ;

i am working on hospital management system. i am using c-sharp on front end and sql server 2000 for back end . i am create relationship between department information table and help desk table . because help desk contain department information . In the department table, the primary key is "department id" and in the help desk table the foriegn key is department id . but after create a relationship when i save my erd diagram . my diagram give this error .


 Unable to create relationship 'FK_help_desk_department information'.

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_help_desk_department information'. The conflict occurred in database 'ooad', table 'department information', column 'departmentid'.

from
sumaira