Hi Sherry,

You can use "USE myview" if you want; like you do in tables!
After "USE" you can use "SELECT". Example:

OPEN DATABASE mydatabase
USE myview
Total = Recno( )

Wait window "My view has " + Alltrim(Str(total)) + "Records"

Select ... && Imagine: SELECT other table
...

SELECT myview
Replace customer_code With "123"

Select * from myview order by 1

----------

As you can see, you can treat a view like a table!

If you detail me your problem, probabily i can help a little more...


Cheers,

Ricardo