>My comment regarding opening tables was in response to Hilmer's comment that Fox will automatically open the tables with an alias if they're already open. It sounded like he meant that when you open the view, the tables associated with that view are automatically opened.
Yes, that is what I meant. I usually don't get the open file dialog. I suspect your program can't find the tables if you don't open them explicitly. Are they along the path?
>I haven't found this to be the case. Maybe it's different if the tables used by the view are part of a database or something, but I always have to make sure my views are opened BEFORE I use my view.
My tables are all part of a database.
But, I think the tables will be found even if you opened them with another alias.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)