The conflict occurred in database
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