Is there a way to do this simply
He could simplify his system greatly by using a related table where each combination of BoltQty and BoltQtyAdd are records in a related table instead of trying to maintain a group of individual fields in the same record. It would also simplify the update that he wants here.
From the existing fields, he could set up a looping script that uses Set field by name and GetField and a counter variable to update field values and access data from fields without having to specify explicit field names.
I have suggested that he use related tables, but he already has everything they he wants now and is ready ready to change from that. What would the option for the existing fields look like?
Yes but you wanted a simpler way to manage it and that simpler way requires a change--which can offer a number of other advantages as well. Consider what has to be done if he finds that he now needs more of these fields. Instead of a simple data entry operation to add another related record, he, or you have to redesign the database to add more fields and update this script.
Set Variable [$K ; value: $K + 1]
Exit loop if [ $K > specify number of these sets of fields here ]
Set Field by Name ["YourTableHere::BoltQty" & $K ; GetField ( "YourTableHere::BoltQTy" & $K ) + GetField ( "YourTableHere::BoltAdd" & $K ) ]
Set Field By Name [ "YourTableHere::BoltAdd" & $K ; "" ]