>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)?

Your error message indicates that your form generates a duplicate record as defined by table's candidate index. It might happen that this index expression includes site code. Basically, check the index and check the saving code.