Hi all,

I have a grid on a form that's based on a view called vSpecialty:

SELECT * FROM rac1!specialty ORDER BY Specialty.name

The table only has 2 fields: specialty_id (prim. key), and name (character).

The grid is based on this view and the purpose is to allow the users to go through the list of Drs. specialties and edit them (i.e. change Stomachology to Gastrology, etc.).

The problem I'm having is that when a change like the above occurrs, the grid's order doesn't get refreshed.

I want the order to be updated every time the specialty is changed to something different, for example, when I change Stomachology to Gastrology, the entry should move up in the list.

I've tried to call refresh from the valid of the textbox and also from the aftercol...change. Even tried to call thisform.refresh(), but nothing seems to work.

What am I missing?

Thanks!

Alex