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.