>Mark,
>
>That just updates the existing index and doesn't add other, correct?
>
>>>I need to change and index expression from a table from the default (field name) to VAL(fieldname). I can do this easily in the Project Manager, but I need to do this on an installed site using commands in an update program.
>>>
>>>I thought I would use an ALTER TABLE command but do I need to DROP the FOREIGN key first (it's a 'regular' key) and then ADD the new key? What would the commands be>
>>>
>>>
>>>Thanks
>>
>>Since it is a regular key, there is nothing to drop, open the table exclusively and issue the command:
>>
>>INDEX ON VAL(fieldname) TAG tagname

Peter, you can also

INDEX ON VAL(FieldName) TAG ValFieldName ADDITIVE

and have both the new and the old index if you want.