>When you issue SELECT mytable, is there any way to specify the DBC? This would be important if you had 2 DBCs open and both DBCs had a table with the same name.
>I've tried SELECT "MyTable!MyDBC" but VFP does not accept this.
>Unless there is some way to do this, I could use the work area number to select the table I want.
>Thanks, Chaim

Chaim,

You can not have open two tables under the same alias in the same DS. You can use this command:

use MyDBC1!MyTable alias MyTableMyDBC1 in 0 (to distinguish)
use MyDBC2!MyTable alias MyTableMyDBC2 in 0 (to distinguish)

IOW, use different aliases to distinguish, otherwise you would have only one table open in one time.