>Just out of curiosity this. I have a form that refers to a table that is neither opened via code nor included in the DE. An SQL select accesses this table and it works OK. Now I know that you don't have to USE ... Select etc a table before it appears in an SQL select generally, but I would have thought the form would need to know exactly where/which table.

In case when table is not open before a query, FoxPro will look for it in the current directory and than along VFP search path (SET("PATH")). The first one found will be open otherwise you'll get Open Table dialog.