Dear all,

I created a form which contains a grid uses personel.dat as it's recordsource indexed as:

USE personel.dat IN 1 SHARED ;
INDEX c:\ppltrack\last,;
c:\ppltrack\first,;
c:\ppltrack\title,;
c:\ppltrack\program,;
c:\ppltrack\location,;
c:\ppltrack\account,;
c:\ppltrack\salary,;
c:\ppltrack\city

I love binding the table to the grid because the user can change records in rows and columns and the data is updated to the table immediately.

However, I would like to have the user click on "Last Name" and have the grid display the data in last name order... my CLICK event (form.grid.column1.header1.click) looks like this:

* index on last name
SELECT personel
SET order to 1
GO TOP
pplmain.tabs.browse.browseview.refresh()

Well, nothing happens! If I halt the form and issue a standard BROWSE the data appears in the correct index order... but nothing ever changes on the form.

Any ideas? Sorry if this has been asked a billion times but I couldn't find the answer...

TIA!

Bryan Friberg
Adams 12 School District Webmaster