Bonnie;

Let me say that I understand what the error means and I am requesting suggestions about how to resolve it. I tried Google and did not find a solution.

Tom

>Tom,
>
>>>Any suggestions?<
>
>None other than to look at your data and see what's contained in the Foreign Key. The error message means just what it says ... you have a Foreign Key in the table you're trying to update that doesn't exist in the "parent" table.
>
>~~Bonnie
>
>
>>Windows 2000
>>SQL Server 2000 SP1
>>
>>Problem:
>>
>>Unable to update column that is a foreign key.
>>
>>Error:
>>
>>UPDATE statement conflict with COLUMN FOREIGN KEY constraint...
>>
>>Any suggestions?
>>
>>Thank you in advance.
>>
>>Tom