I have what I think should be a simple problem, but I don't see a solution. It's sort of like I want to

SET RELATION TO bla-bla IM MyTable INTO MyTable

which of course makes no sense.

It simplest terms, I have a cursor with four fields: Part, Site, Value1, and Value2. For each Part, I have four records, one for each Site. (The Sites are named "A", "B", "C", and "D".)

What I'd like to do can be stated quite simply: For each Part, take Value1 for Site="C" and store it into Value2 for Site="B". Thus:

Part   Site    Value1   Value2

ABC    A         11       88    
ABC    B        201      255
ABC    C         77       66
ABC    D        401      444

Becomes

Part   Site    Value1   Value2

ABC    A         11       88
ABC    B        201    => 77 <=
ABC    C         77       66
ABC    D        401      444