Robin,
Add the keyword NOFILTER to your query. For simple queries like yours, FoxPro simply filters the original table. NOFILTER was added to VFP5. In older versions you could work around this by adding something to your query, eg. SELECT *, "" AS dummy FROM MyTable INTO CURSOR MyCursor
HTH
>Maybe I'm missing somthing :-
>
>As a test I do :
>
>Select * from table into cursor cursor1
>
>and then...
>
>Select * from cursor1 into cursor cursor2
>
>On my PC it works fine but on my laptop is says 'Cursor2' must be created with select into table.
>
>I have tried copying the foxuser onto my laptop from my pc but this does not work. Waht is the setting that causes this?.
>
>Please help,
>Rob
Daniel