Every time I create a table as a result of an sql query it uses the work area of one of my open files - is there any way I can I can make it open in a specific work area?

Another question - how do I check to see if a table is open?

Thanks

Colin