>Hi.... I'm a new user of foxpro and i have a very simple question... is there any logical reason to build a view that is the exact replicate of the table??
>
>Thanks

Not in terms of selecting all the records. I create parameterized views that include all fields but only a select number of records that meet a certain value of a parameter. e.g.:

create sql view my view as ;
   select * from mytable where city = ?cCity ;
   order by whatever

Option #1:

use MyView Nodata
cCity = "Dallas"
requery("MyView")

Option #2

cCity = "Dallas"
use MyView