Using the latest 7.6 RBASE. Below is the code I use to bring up the WHERE builder for the OrderHeader table.
This will print a report based of course on the WHERE clause. SET ERROR MESSAGE 2045 OFF CHOOSE vchoice FROM #WHERE IN OrderHeader SET VAR vcount INTEGER = 0 SELECT COUNT (*) INTO vcount IND vin0 FROM OrderHeader &vchoice IF vcount > 0 THEN PRINT KPRPartNeedIrv2010 &vchoice ELSE Etc, etc If we type in the column name Control# IN (etc,etc) the report prints to the screen as it should. If we use the WHERE builder buttons (double clicking on the columns we want to use) this error comes up: 'Correlation OrderHeader not found ERROR 2366.' Why would it work if we type in the columns, but not work if double clicking the column names? The only difference is the double click puts Orderheader. In front of the column name. I have not had this problem in other areas I use the WHERE builder like this. Jim
