Hi,

>Can you change this into 'select * from MyTable', ie without the mydbc!

Thanks for the suggestion - that works. Guess I'll have to stay away from the view designer *and* ignore the documentation in this instance. Still odd (and I'd claim wrong) that VFP should make a different choice with the DBC name specified.

Thanks again,
Viv