I am trying to change the text group for a number of rows in table tttxt001 using a program script. The problem is that the text group (tttxt001.txtg) is part of index 2 & I am getting an error message when doing the db.update.

Is there any way of updating a field if it is present in a secondary index?

Which error message? Are you sure you don't try to produce "duplicate records" ?

Sorry, no better idea at the moment!

Spartacus

The tttxt001.txtg field has a reference to the tttxt005.txtg

I think you need to have the text group defined for that company before you actually modify one text group with another.