>Thanks. I knew it would be something simple. Now my code reads SELECT red,yellow,blue from MainTable NOCONSOLE;
>WHERE orange IN (SELECT orange FROM cursor2)...but the NOCONSOLE is not working. This query is designed to go directly to a report, which it does nicely, but before it does this browse window opens. Why doesn't the NOCONSOLE supress it?
There is no NOCONSOLE clause. You need to specify an INTO CURSOR clause. The default cursor name used by VFP if none is specified is "Query"