Hi Alex.

>> I did this, but the index never got updated. Here's what I did:

use vspecialty
index on lower(name) tag name

browse && got the records in alpha order.

use in vespecialty

brow && now the records are in natural order again. <<

This is what I would expect to happen. The index on a view (just like the index on a cursor created from a SQL select) is temporary. When you close the cursor, the index goes poof ;-)

Marcia