>>
Set the column1 control source to the first column of test and set column2 control source to the third column of test.
<<

This is where your problem rests. You need to make sure the columns of the grid match the columns of the cursor. Any cursor columns you don't wish to display need to be places AFTER the columns that you do wish to display.



>John,
>
>Try this in VFP 6.0:
>
>Using sql select some records from a table into a cursor called test. (The cursor must have atleast 3 columns. Now drop a base class grid on a form with a column count of 2. Make the record source 'test' with the recordsource type alias. Set the column1 control source to the first column of test and set column2 control source to the third column of test. Then run the form and note the contents of column 2 in your grid. Now run your sql again. Column 2 in your grid will no longer display the third column of test, it is column 2 instead.