error message

[shaminda]

I have a VB program that runs 24 hours a day in about 8 machines. I get the following error, and I can't figure out the problem.

-2147217900 [MICROSOFT][ODBC SQL SERVER DRIVER][SQL SERVER] INSERT STATEMENT CONFLICTED WITH TABLE FOREIGN KEY CONSTRAINT 'FK_ITEMORDER_SHIFT'. THE CONFLICT OCCURED IN DATABASE 'lotctrl' TABLE 'Shift'

Does anybody know the meaning and the solution for this error?

 

[Antzz]

This error means :
In the database "loctrl" you have a table "shift" where you have defined a foreign key constaint or rule by the name of "FK_ITEM_SHIFT". Now one of the row inserts that you are trying to perform violates this rule.
You can look into the contents of the rule and see what exactly it says. Also you can trap the offending record by displaying a part of the record just before the execution of the insert statement(if u r using VB)