I'm creating a form that gets a little input & then copies data to a floppy disk. The processing involves 5 data tables. In the form, in the data environment, the tables are all listed. I've also set the order for the tables. In the click method of a button, where I do the processing, when I refer to a table, I tried to use SELECT. I got the message, table is not open. I had to then use the DOS method of SELECT 1, USE table name, etc. What did I do wrong? Why doesn't SELECT table name work?

TIA