Yes, but I get the "uniqueness is violate" error message. That is the part I am trying to understand since I am not changing the key fields. The site code is different.

>This update command tries to change all records in the table. Is it the intent?
>
>>The record is not deleted. The fields be updated have regular indexes. The field for which I get the error message has a candidate index.
>>It is not in the update list. My command is
>>

>>	UPDATE relpos SET ;
>>		ccomment	= Thisform.ccomment		,	;
>>		corderby	= Thisform.orderby		,	;
>>		crecoeved	= Thisform.received		,	;
>>		creleased	= Thisform.released	,	;
>>		cvname		= Thisform.vname
>>

>>>>>>The user is logged in for a particular site (i.e. A) and wants to change all values except the site code. In a from I can find the record, When I try to change the I get an error message that the uniqueness of the record is violated. I use the UPDATE command. Is there a may of updating the record or do I have to tell the user to log on with that site (my current statutory)?
>>>>>
>>>>>See if you have an empty deleted record in this table in addition to Ed's suggestion. Pack the table if this is the case (requires exclusive access).
>>>>
>>>>It is better having NOT DELETED() filter on the candidate index.
>>>
>>>I don't like having filters on indexes at all. But you're right, of course.