I think so you have this tables
Orders related to detailorders, product related to components and detailorders related to product
All tan you can make is:
Create a form and put two textboxes and a command button.
The first is to type the current part number and the second is for type the new value
Create a new methed for your form and call this at the click event of the command button
In the method set this code:

Local lastValue, newValue
lastValue = Thisform.Text1.Value
newValue = Thisform.Text2.Value
Replace PARTNO With newValue All for PARTNO = lastValue
* If you are working with table buffering or record buffering
=TableUpdate(.T.)



Thats all

Mauricio