Lynda,


Did you try to open the prodata.dbc before processing the view?

For a table that is in the DBC, you can open it either by giving the fullpath and file name (as you would do for a free table) or just the table name (as it is stored in the DBC).

So, you can give
OPEN DATA PRODATA
CREATE SQL VIEW AS SELECT * FROM ARCUST01

or
CREATE SQL VIEW AS SELECT * FROM c:\pro71\ardata01\arcust01.dbf

Since you mention a form, maybe the form is set to have a private data session, in which case you would have to put the following line in the Load Event of the form
SET DATABASE TO prodata

HTH

- Dan