Use NOFILTER if you want a new table as opposed to a filtered view of the original table.
>Please note the following SELECT
>

>	SELECT mitem.subhead, mitem.uniqueid ;
>		FROM a09mitem mitem ;
>		INTO CURSOR abc
>

>
>This is the DISPLAY STATUS after the SELECT is run
>

>Select area:  1, Database in Use: C:\VSO2\SW\A09\CMP00001\A09MITEM.DBF    Alias:
> A09MITEM
>           Code page:   0
> Structural CDX file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.CDX
>           Index tag:   UNIQUEID   Collate: Machine   Key: UNIQUEID
>           Memo file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.FPT
>       Lock(s): Exclusive USE
>
>Currently Selected Database:
>Select area:  2, Database in Use: C:\VSO2\SW\A09\CMP00001\A09MITEM.DBF     (Read
>only) Alias: ABC
>           Code page:   0
> Structural CDX file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.CDX
>           Index tag:   UNIQUEID   Collate: Machine   Key: UNIQUEID
>           Memo file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.FPT
>       Lock(s): Exclusive USE
>

>
>The CURSOR abc is my original file reused shouldn't it be a temp file???
>
>
>Now notice this SELECT
>

>	SELECT mitem.subhead, mitem.uniqueid ;
>		FROM a09mitem mitem ;
>		WHERE .T. ;
>		INTO CURSOR abc
>

>
>This is the DISPLAY STATUS after the SELECT is run
>

>Select area:  1, Database in Use: C:\VSO2\SW\A09\CMP00001\A09MITEM.DBF    Alias:
> A09MITEM
>           Code page:   0
> Structural CDX file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.CDX
>           Index tag:   UNIQUEID   Collate: Machine   Key: UNIQUEID
>           Memo file:   C:\VSO2\SW\A09\CMP00001\A09MITEM.FPT
>       Lock(s): Exclusive USE
>
>Currently Selected Database:
>Select area:  3, Database in Use: C:\TRASHCAN\81557496.TMP     (Readonly) Alias:
> ABC
>           Code page:   0
>       Lock(s): Exclusive USE
>

>
>What say!!!