>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?
NOCONSOLE is a REPORT FORM directive, not an SQL directive.
YOu need to assign the results of your query to a cursor:
SELECT Whatever FROM Whatever INTO CURSOR MyCursor
Then your report fields should be looking at MyCursor.Whatever
Erik Moore
Clientelligence